U++ forum: Welcome to the forum

Re: firebird with sqlarray ctrl (possible?) [message #41830 is a reply to message #41823]

Mon, 27 January 2014 10:27

mirek
Messages: 13976
Registered: November 2005

Ultimate Member

mtdew3q wrote on Sun, 26 January 2014 16:13

HI-

I fooled around today with Firebird from the bazaar.

In the code below, I noticed that only some of the Sql class seems to work. When I try to use SqlId, it complained.

I don't know what to use for this line:
SqlSchema sch(SQLITE3); //I tried (FIREBIRD)

To keep it simple, I don't get how to use SqlArray or schema. Is it possible? I think I remember getting an error that said something about dialect. I like Novos code with Ultimate better than trying to use IBPP.

thanks very much!
mtdew3q

FBSession s;
s.Connect(
	"c:\\Users\\airport\\data\\TEST.fdb",
	"localhost:xxxx",
	"dodo",
	"bird"
			);
		
 String s1;
 SqlId ITEM_ID("ITEM_ID"),MENU("MENU");
 Sql sql(s);
 //sql.SetStatement("select * from sales_catalog");
 //sql.Execute();
 sql * Select(ITEM_ID).From(MENU);
 while(sql.Fetch()){
   s1= sql[0];
   PromptOK(s1);  
	     
//	Cout() << stmt[0] << '\n'  ;
	 
}

I have not used Firebird yet, but that "driver" part of Sql is quite unrelated to SqlId or SqlArray, so I guess the problem your are reporting might not be quite related to Firebird per see.

Have you gone through SQL tutorial?

http://www.ultimatepp.org/srcdoc$Sql$tutorial$en-us.html

Report message to a moderator