U++ framework
Do not panic. Ask here before giving up.

Home » U++ Library support » U++ SQL » First Firebird for U++ steps
Re: First Firebird for U++ steps [message #17088 is a reply to message #17083] Mon, 28 July 2008 14:40 Go to previous messageGo to previous message
aldeacity is currently offline  aldeacity
Messages: 18
Registered: July 2008
Location: Spain
Promising Member
Hello,

I send a sample testing datagrid. All columns seem to be ok, of course expect salary column that it's decimal(10,2). I.m adapting FireBirdSchema.h now.

Database is Firebird test database (EMPLOYEE.FDB).

Query is:
SELECT EMP_NO, FIRST_NAME, LAST_NAME, SALARY, FULL_NAME FROM EMPLOYEE;

Schema is:
TABLE_(EMPLOYEE)
INT_ (EMP_NO)
STRING_ (FIRST_NAME)
STRING_ (LAST_NAME)
STRING_ (SALARY)
STRING_ (FULL_NAME)
END_TABLE

Code for datagrid is:
frmTest.grdData.SetTable(EMPLOYEE);
frmTest.grdData.AddColumn(EMP_NO, "Emp. No.");
frmTest.grdData.AddColumn(FIRST_NAME, "First Name");
frmTest.grdData.AddColumn(LAST_NAME, "Last Name");
frmTest.grdData.AddColumn(SALARY, "Salary");
frmTest.grdData.AddColumn(FULL_NAME, "Full Name");
frmTest.grdData.Query();

Juan.
  • Attachment: datagrid.zip
    (Size: 32.52KB, Downloaded 511 times)
 
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: FireBird plugin and test program
Next Topic: SQLite: Date and Time
Goto Forum:
  


Current Time: Mon Nov 02 02:29:50 GMT+1 2026

Total time taken to generate the page: 0.04837 seconds