Subject | Re: SV: [firebird-support] insert script |
---|---|
Author | Net Newbie |
Post date | 2011-11-30T16:58:55Z |
Yes. I use IBExpert. I also managed to solve the issue. if I run it
under SQL Editor I get this error. If I run it from Script Executive
window of IBExpert it works. seems different editor of IBExpert behave
differently.
under SQL Editor I get this error. If I run it from Script Executive
window of IBExpert it works. seems different editor of IBExpert behave
differently.
On 30.11.2011 17:55, Poul Dige wrote:
>
> My guess is that you don't use a script tool but a normal SQL-tool in
> e.g. IBExpert?
>
> Regards,
> Poul
>
> Fra: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>] På vegne af Net Newbie
> Sendt: 30. november 2011 00:23
> Til: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Emne: [firebird-support] insert script
>
> FB 2.5
>
> I need to insert data with a script. but get an error
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 2, column 1.
> INSERT.
>
> the script itself is like below- any ideas what is wrong?
>
> INSERT INTO CAR_MARK ("car_mark_id", "car_mark_name") VALUES (1, 'test ');
> INSERT INTO CAR_MARK ("car_mark_id", "car_mark_name") VALUES (2, 'test
> two');
> INSERT INTO CAR_MARK ("car_mark_id", "car_mark_name") VALUES (3, 'test
> three');
>
[Non-text portions of this message have been removed]