CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 CodeCharge Form SQL Section

Print topic Send  topic

Author Message
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.
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.