Home » U++ Library support » U++ SQL » Workaround: Hybridizing SqlExp usage
| Workaround: Hybridizing SqlExp usage [message #25663] |
Sat, 06 March 2010 21:52 |
alendar
Messages: 47
Registered: January 2010
Location: Idaho, USA
|
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)))
{
cd7651feeb698f6ac6cec1f6deda5e5b
[Updated on: Sat, 06 March 2010 22:01] Report message to a moderator |
|
|
|
Goto Forum:
Current Time: Thu Apr 18 02:44:34 CEST 2024
Total time taken to generate the page: 0.02436 seconds
|
Members
Pages
Help
Register
Login
Home
