Hello,
I was doing the mysql data entry via kmysql which allows me to build forms
and then Enter the data according to the script that I create which runs when
I hit the submit problem. I tried to do something similar via
mysql_navigator and it dies. The script (which are valid mysql commands)
goes something like this (I'm using 2 tables, one is an address table and the
other is a property table).
select (@store:=ID) from Address where Company='Wal-Mart';
insert into Property (Bought,Owner,Type,Room,Make,Store,Cost) values
(@store,'Doug','Toys','Office','Digital Camera',@store,39.46);
The field descriptions are as follows:
Bought date
Owner set('comma','deliminated','family','members','Doug')
Type enum('Appliance','Electronic','Tools','Toys')
Room enum('Living','Office','Kitchen','etc')
Make varchar(30)
Store int(10) unsigned
Cost double(10,2)
When I run the same basic script in kmysql, it works fine (except I can do a
bit more as far as introducing new variables). When I try to run it in
mysql_navigator on the other hand, it errors out and won't tell me via log or
any other means I can determine what the errors are.
Can anyone tell me what I'm doing wrong in mysql_navigator?
Thanx Loads!
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
