Syntax correction: insert into autopsy (spleen) values (100)
Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 3:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Database Limits, again? I asked this a long time ago but cannot find the answer to it, and couldn't find it on the RBase website or in my books. Remind me again how many columns you can have in a table? Because of a client who INSISTS that I design a table a certain way, I have 748 columns. The table is fine, I can see it and list its definition just fine. Some column names are at the max of 18 characters. Most of the data is REAL type. But if I try to insert data in it with a simple: insert into autopsy (spleen) values 100 (yes that is the correct table and column name) I get an access violation. At that point the table definition disappears and I cannot even do a Disconnect. I was starting to design a form for it, and having no problem with that up to the point I was at. So I wanted to insert a row of data so I could edit using the form, and I couldn't get data into the table! The client is on 7.1 (which is when this project began), and I asked the question back then because I wanted to make sure 7.1 could handle it. I was told that it could. But I tried this on 7.6 and I get the same result. Karen
