Ultimate++ forum: U++ SQL: Sql/SqlCtrl/Oracle/MySql/OleDB => Workaround: Hybridizing SqlExp usage

Search on this site

Members

Help

Home

Home » U++ Library support » U++ SQL: Sql/SqlCtrl/Oracle/MySql/OleDB » Workaround: Hybridizing SqlExp usage

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Workaround: Hybridizing SqlExp usage [message #25663]

Sat, 06 March 2010 21:52

alendar
Messages: 29
Registered: January 2010
Location: Pennsylvania, USA

Promising member

I found that SqlExp is flexible enough to let me use it halfway, which really helps.

I needed to reference a different schema in my MySql database, but as far as I know there is no way to prefix my table name identifiers with the schema. I often have to reference multiple schemas in a single query, so I'm glad I found a way.

Here's what I did:

if (!(lst * 
	Select(SqlCountRows())
	.From(SqlId("information_schema.tables"))
	.Where(SqlId("table_name") == localUserTableName)))
{

[Updated on: Sat, 06 March 2010 22:01]

Report message to a moderator

Previous Topic:	truncated double values from mysql
Next Topic:	Compiling error for mysql

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 9 19:34:31 CEST 2010

Total time taken to generate the page: 0.01275 seconds

.:: Contact :: Home ::.