Welcome
Welcome to <strong>txtSQL</strong>.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, <a href="/profile.php?mode=register">join our community today</a>!

Table name with integers does not work

Post bugs here

Table name with integers does not work

Postby ronghester on Mon Dec 01, 2008 6:18 am

I am using txtsql for parsing purpose.
When ever sql statement contains a table with intergers in it txtsql is not able to handle
that statement.

example if i execute the statement like (name of the table is 'table1')
Delete from table1 where cat="mini";

txtsql is not able to parse this statement that means
txtSQL.lexer.parse() returns false

If we add single quote to that table name then it will get parsed properly
but in mysql this kind of statement also works.

Is there any way to make txtsql enable to take up table names that will
contains integers.

i am using txtsql version 4.0a

looking forward to get some help
ronghester
 
Posts: 4
Joined: Tue Aug 12, 2008 7:53 am

Re: Table name with integers does not work

Postby zzw08 on Tue Jul 14, 2009 5:32 am

http://www.fashion-products.com [url=http://www.fashion-products.com ]is a sell air force one,
air jordan,bape,kicks,nike,Jerseys,Shoes,Clothing,Bag,Glasses,Caps&Hats,sneakers,sunglasses,
watches,Jewelry,Electronics,NBA,NFL,NHL,MLB[/url]
shoes
clothing
Handbags Wallets
Hat
Sunglasses
Belts
Watches
Jewelry
zzw08
 
Posts: 53
Joined: Tue Jul 14, 2009 5:15 am


Return to Bugs

Who is online

Users browsing this forum: No registered users and 0 guests

cron