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 » Postgres and CurrVal
Re: Postgres and CurrVal [message #23185 is a reply to message #23138] Thu, 24 September 2009 10:42 Go to previous message
mirek is currently offline  mirek
Messages: 14267
Registered: November 2005
Ultimate Member
Zbych wrote on Fri, 18 September 2009 04:25

luzr wrote on Thu, 17 September 2009 17:26


And your opinion about the 'syntax'? Any ideas?


Do you mean upp syntax or sql syntax?
Upp syntax (Next() and /) is ok for me. I've made some changes in SqlInsert to support Next() and it works with postgres.

I don't know if SqlInsert should be idiot proof and allow to mix order of columns?
Insert(TABLE)
(COL1, "aaa")(COL2, "bbb").Next()
(COL2, "ccc")(COL1, "ddd").Next()  //switched columns
(COL1, "eee"); //one column is missing 




Well... Maybe we should rather opt for special "MultiInsert" class for this, with different interface...

In any case, there is sort of problem with sql "compiler" internals. Those completely different syntaxes of Oracle and Sqlite3 would make internal representation (using SqlCase) too long, with all values repeated 3 times...

OTOH, maybe this could solve the problem of missing columns..
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Acquiring large record
Next Topic: Can I use Upp::Oracle8 connect to Oracle10?
Goto Forum:
  


Current Time: Sun Aug 24 14:34:03 CEST 2025

Total time taken to generate the page: 0.04970 seconds