U++ forum: Welcome to the forum

firebird with sqlarray ctrl (possible?) [message #41823]

Sun, 26 January 2014 22:13

mtdew3q
Messages: 181
Registered: July 2010
Location: Upstate, NY (near Canada)

Experienced Member

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'  ;
	 
}

Report message to a moderator