I have a db that has a table containing 30-40 fields. When i try to use this table to create a record set (or a record insertion form) none of the field names show up. I can click on test and get results, but i can't select which fields i want. is this a known problem?

Greg Cameron

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>... a table containing 30-40 fields....<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<img src=../images/dmxzone/forum/icon_smile_shock.gif border=0 align=middle> Wow... which server behavior are you trying to use?

that's a strange prob. try this... it might be a work around, but it just may work...
make a simple recordset that is just selecting all of the fields.
that would make a SQL statement that looks something like this.
<pre id=code><font face=courier size=2 id=code>SELECT * FROM table</font id=code></pre id=code>
Then go into code view and find the SQL, and replace the "*" with your field names (comma separated of course)

do the extensions work with smaller tables?

Joel Martinez

----------
Is this thing on?....

Thank you for your reply. I am not using any behaviors and I am using a simple record set, but the fields do not show up. <img src="" border=0>

Greg Cameron

Macromedia mentions nothing about limits, some time ago i successfully connected to a Oracle database that went WAY past what you describe and it listed ALOT of tables, must've been 100's almost all of those tables had more fields then you describe, my system was running very slow though, sometimes when processing large amounts of data, even if you're not requesting the actual records yet, you might want to give it a few minutes to finish processing, on slower machines i recommend not trying this, but i build me a page once with 26 record queries and it took over 3 minutes to process on my Athlon 1200, doing everything locally, imagine me doing this at work, on my 500MHz P3 NT workstation requesting the data over the LAN, ok, i'll come back tomorrow guys...

So, obviously something else is happening.
Are there spaces in your table names ? UDev hates spaces in databases.

With kind regards,

Dennis van Galen
Webmaster SPG Finance
KPN Telecom Holland NV

Well.. maybe it makes the difference that you are using an Athlon 1200 and this person for eqample a much slower machine?

Well.. I think that only a Macromedia technician can give you a really good answer on this question. As far as I can say: I have never noticed it.

What Dennis says about the spaces is defenitely true: check that one out.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

Thanks all for your replies. There are no spaces or other funky characters in any of the field names. I am using a compaq armada m700 pIII 700mhz 256mb ram. I'll keep digging and see what I can work out.

Greg Cameron

I recreated the table from scratch and it now displays????? very wierd nothing really different about the two tables. Thanks to those who replied.

Greg Cameron