Forums

i created a new form and when i wanted to create a table this error came up:

"Query was empty SQL="

how do i fix this???

Hi, show me your form code, did you choose any table fields when creating it ?

Regards
Max

i found the problem...
when you said to show you the form code i had a look and the names of the fields had non-normal characters in it such as "[]" etc.
i removed these and had just normal alphanumeric characters and now it works!
thanks for the spur on!

No problems, having [] ONLY, is fine, but any spaces or - or other special characters, will make troubles yes!

Regards
Max

Red-faced... I was having this problem too, so just in case it helps any other idiots... you'll get this message if you don't click any checkboxes under "Create Column!" DUH!!!!