Goede morgen,
and thank you for your suggestion.
I am actually wondering if the difference between lasso 8.1 and 8.6 is so big
that traditional lasso code can not be used when connecting w/ MySQL ?
You mentioned "... This can be done in the server configuration, so no
alterations are necessary
On Wed, 2011-07-06 at 11:03 -0400, Martin Gainty wrote:
> Rik and Crew
Please keep your replies to the list only, I don't need to double on
e-mail...
> String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are
> enabled
> Column names are never surrounded by ticks or double quotes
Rik and Crew
String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled
Column names are never surrounded by ticks or double quotes so
TABLE table_name
FOO VARCHAR(30)
where the INSERT statement for table table_name column FOO would look like:
INSERT INTO table_name FOO VALUE
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote:
> On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
> > (error code) 1064
> > (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax;
> > check the manual that corresponds to your MySQL server version for the
> > right
On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
> (error code) 1064
> (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the right
> syntax to use near '"DMPPRuser") VALUES ('MYNAME')' at line 1
Hi,
I started with lasso 3.x & FMP, jumped to lasso 8.5 with SQLlite (and loved
it), now need to work with MySQL and Laso 8.6 (on Mac mini with Snow Leopard
server 10.6.7 ). I am not a programmer but quite familiar with the traditional
encoding when using lasso. Now the question:
I created