Re: [gnome-db] Select in MDB table file with '_'

[Filip Van Raemdonck <mechanix debian org>]

On Sat, Jan 31, 2004 at 12:05:41AM +0100, Miguel Angel wrote:
> Hello,
> Why don't work this select with 1.0.2 and 1.03 libgda
> "SELECT * FROM TABLE_EXAMPLE"  ?
>  
> I get this error:
> TABLE is not a table in this database
> Error at Line : parse error near _
> 
> 
> the problem is the char '_' , but this select works with mdb-sql 

Hmmmm...

1 => SELECT * FROm a_b
2 => go
a is not a table in this database
Error at Line : syntax error near _
Could not parse 'SELECT * FROm a_b
' command
1 =>


The only way I can see that gda-mdb and mdb-sql would give different
results is if they use a different libmdbsql library.


Regards,

Filip

-- 
"The MS-DOS filesystem is nice for removable media."
	-- H. Peter Anvin