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 » How to access a firebird database ?
Re: How to access a firebird database ? [message #10058 is a reply to message #8305] Mon, 18 June 2007 16:52 Go to previous messageGo to previous message
jibe is currently offline  jibe
Messages: 294
Registered: February 2007
Location: France
Experienced Member
Hi,

Still trying to make this plugin for Firebird, but as I have few time to do that and study UPP, it's not yet working... I think I'll ask here some basic questions rather than trying by myself to discover though the code how it works, or I'll never finish... Confused Sorry for that...

1) I'm afraid I did my FirebirdSHema.h the wrong way... Please, could you explain what must be the C++ types, Database types etc. in this code :

#define INT(x)                     COLUMN("integer", int, x, 0, 0)
#define INT_ARRAY(x, items)        COLUMN_ARRAY("integer", int, x, 0, 0, items)
#define INT_(x)                    COLUMN_("integer", int, x, 0, 0)
#define INT_ARRAY_(x, items)       COLUMN_ARRAY_("integer", int, x, 0, 0, items)

Seems that I have some difficulties to find the right syntax, as some types don't work properly... What is INT, "integer" and int ?

2) What do you call a dialect ? Seems it is (an arbitrary number related to) the database engine ?

ASSERT(dialect == ORACLE || dialect == SQLITE3 || dialect == MY_SQL || dialect == MSSQL ||
	       dialect == POSTGRESS || dialect == FIREBIRD || dialect == DB2);

In Firebird, there is 2 dialects (dialect 1 and dialect 3). How can I manage it ? But first, must I consider these 2 dialects ? dialect 1 is just to have a compatibility with an old version of Interbase. Maybe we could just ignore this one ? Firebird user's opinion is welcome about that as well as UPP developper's !
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: PostgreSQL fieldname case bug
Next Topic: PostgreSQL issues
Goto Forum:
  


Current Time: Tue Jul 08 21:33:38 CEST 2025

Total time taken to generate the page: 0.03693 seconds