Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Workaround: Hybridizing SqlExp usage
Workaround: Hybridizing SqlExp usage [message #25663] Sat, 06 March 2010 21:52
alendar is currently offline  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

Previous Topic: truncated double values from mysql
Next Topic: sqlite and Execute
Goto Forum:
  


Current Time: Wed Sep 18 15:37:04 CEST 2019

Total time taken to generate the page: 0.01408 seconds