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   |
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 401 times)
|
|
|
Goto Forum:
Current Time: Fri Sep 05 12:55:24 CEST 2025
Total time taken to generate the page: 0.05651 seconds
|