Mark Crowley
|
Posted: 04/03/2001, 4:28 PM |
|
Hi,
I am currently evaluating the suitability of CodeCharge for a project that I
am working on. In an attempt to enter SQL directly into the "USE SQL STRING"
text area on the SQL tab of the form properties I repeatedly get an error
when I hit the OK button. The error reads "Invalid SQL Query". I have gone
through a number of permutations of equally valid SQL statements which
CodeCharge rejects every time. I would rather use this feature than modify
the generated code for obvious reasons. My application topology consists of
the MySQL/PHP combo.
Any suggestions would be greatly appreciated.
Regards,
Mark
|
|
|
Walker P.
|
Posted: 04/23/2001, 3:28 PM |
|
"Mark Crowley" <markcrowley@eircom.net> wrote in message
news:9adma2$6r1$1@mail.tankhill.com...
> Hi,
>
> I am currently evaluating the suitability of CodeCharge for a project that
I
> am working on. In an attempt to enter SQL directly into the "USE SQL
STRING"
> text area on the SQL tab of the form properties I repeatedly get an error
> when I hit the OK button. The error reads "Invalid SQL Query". I have gone
> through a number of permutations of equally valid SQL statements which
> CodeCharge rejects every time. I would rather use this feature than modify
> the generated code for obvious reasons. My application topology consists
of
> the MySQL/PHP combo.
>
> Any suggestions would be greatly appreciated.
>
> Regards,
>
> Mark
>
>
>
|
|
|
Walker P.
|
Posted: 04/23/2001, 3:31 PM |
|
Mark,
could you post an example SQL statement and the details of the tables you
are using.
Perhaps we can scope out something given some examples
Walker P.
|
|
|
Ryan Kelley
|
Posted: 05/04/2001, 12:26 PM |
|
I am having a very similar problem and here are my SQL statements:
DELETE FROM tblinventory;
INSERT INTO tblinventory SELECT tblwest.* FROM tblwest;
INSERT INTO tblinventory SELECT tblnc.* FROM tblnc;
INSERT INTO tblinventory SELECT tblsc.* FROM tblsc;
Could you please help
Thanks,
Ryan Kelley
"Walker P." <walkerp@codecharge.com> wrote in message
news:9c2agf$qqt$1@mail.tankhill.com...
> Mark,
> could you post an example SQL statement and the details of the tables you
> are using.
> Perhaps we can scope out something given some examples
>
> Walker P.
>
>
|
|
|
|