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 » 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 401 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: Fri Sep 05 12:55:24 CEST 2025

Total time taken to generate the page: 0.05651 seconds