Firebird Front

20
Feb/09
0

Thanks for visiting our site!
Firebird Front
Checkout Ebay Auctions For The Cheapest Prices

98-02 00 PONTIAC FIREBIRD FORMULA FRONT REINFORCEMENT
98-02 00 PONTIAC FIREBIRD FORMULA FRONT REINFORCEMENT
Paypal   US $33.28
1969 GTO / FIREBIRD FRONT SIDE MARKER RETAINING CLIP
1969 GTO / FIREBIRD FRONT SIDE MARKER RETAINING CLIP
Paypal   US $12.00
93 94 Camaro Firebird 32mm Used Front Brake Rotor LOTS OF LIFE LEFT MINOR GROOVE
93 94 Camaro Firebird 32mm Used Front Brake Rotor LOTS OF LIFE LEFT MINOR GROOVE
Paypal   US $9.99
FIREBIRD TRANS AM GTA FRONT SEAT SWITCH TAN 86-92 87
FIREBIRD TRANS AM GTA FRONT SEAT SWITCH TAN 86-92 87
Paypal   US $19.99
67 68 69 70-72 Firebird Trans Am Front Brake Hose NOSR
67 68 69 70-72 Firebird Trans Am Front Brake Hose NOSR
Paypal   US $35.00
70-81 CAMARO FIREBIRD FRONT COIL SPRINGS V8 ORIGINAL   NICE SHAPE
70-81 CAMARO FIREBIRD FRONT COIL SPRINGS V8 ORIGINAL NICE SHAPE
Paypal   US $39.99
1993-02 Chevy Camaro Pontiac Firebird Front Control Arm Bushing Kit Red Poly
1993-02 Chevy Camaro Pontiac Firebird Front Control Arm Bushing Kit Red Poly
Paypal   US $46.89
1998-2002 Camaro & Firebird, 2001-2004 Avantu II -Front Semi-Metallic Brake Pads
1998-2002 Camaro & Firebird, 2001-2004 Avantu II -Front Semi-Metallic Brake Pads
Paypal   US $35.75
82 -92 CHEVY CAMARO FIREBIRD TRANS AM LH FRONT SIDE MARKER LIGHT
82 -92 CHEVY CAMARO FIREBIRD TRANS AM LH FRONT SIDE MARKER LIGHT
Paypal   US $10.99
82-87 88 89 90 91 92 FIREBIRD L. CALIPER FRONT
82-87 88 89 90 91 92 FIREBIRD L. CALIPER FRONT
Paypal   US $15.00
1974-81 Camaro/Trans AM Firebird Metal Headliner Trim Front and Rear -OEM- Good
1974-81 Camaro/Trans AM Firebird Metal Headliner Trim Front and Rear -OEM- Good
Paypal   US $29.99
82-92 CAMARO Z28 FIREBIRD TA FRONT HOOD BUMP STOPS
82-92 CAMARO Z28 FIREBIRD TA FRONT HOOD BUMP STOPS
Paypal   US $19.99
FIREBIRD DRIVER FRONT UPPER CONTROL ARM
FIREBIRD DRIVER FRONT UPPER CONTROL ARM
Paypal   US $60.00
FIREBIRD PASSENGER FRONT UPPER CONTROL ARM
FIREBIRD PASSENGER FRONT UPPER CONTROL ARM
Paypal   US $60.00
74-76 TRANS AM FIREBIRD FRONT HEADER PANEL HEADLIGHT BUCKETS 75 SD
74-76 TRANS AM FIREBIRD FRONT HEADER PANEL HEADLIGHT BUCKETS 75 SD
Paypal   US $12.00
1970 TRANS AM FIREBIRD FRONT LIGHTS CHROME RETAINING RING LARGE DIA.
1970 TRANS AM FIREBIRD FRONT LIGHTS CHROME RETAINING RING LARGE DIA.
Paypal   US $12.00
NOS 1976 Firebird Front Bumper Bracket  (left or right), GM 500579
NOS 1976 Firebird Front Bumper Bracket (left or right), GM 500579
Paypal   US $21.99
1967-68 Camaro / Firebird Front Spoiler With Hardware
1967-68 Camaro / Firebird Front Spoiler With Hardware
Paypal   US $39.99
82-92 CAMARO Z28 RS FIREBIRD TRANS AM FRONT SEATBELTS LEFT AND RIGHT SIDE GRAY
82-92 CAMARO Z28 RS FIREBIRD TRANS AM FRONT SEATBELTS LEFT AND RIGHT SIDE GRAY
Paypal   US $60.00
FIREBIRD FORMULA FRONT SPOILER RH BUMPER PLATE
FIREBIRD FORMULA FRONT SPOILER RH BUMPER PLATE
Paypal   US $49.00
82-92 Firebird Front Fender Air Extractor Vent Mounting Clips  PAIR
82-92 Firebird Front Fender Air Extractor Vent Mounting Clips PAIR
Paypal   US $8.95
82-92 Firebird Driver Side Front Fender Air Extractor Vent   85-92 Style  RARE
82-92 Firebird Driver Side Front Fender Air Extractor Vent 85-92 Style RARE
Paypal   US $29.95
1982-92 Chevy Camaro Pontiac Firebird Front Control Arm Bushing Kit Red Poly
1982-92 Chevy Camaro Pontiac Firebird Front Control Arm Bushing Kit Red Poly
Paypal   US $48.93
70-81 CAMARO FIREBIRD PASSENGER FRONT SEAT TYPE LT BABY BLUE RIGHT RH SIDE
70-81 CAMARO FIREBIRD PASSENGER FRONT SEAT TYPE LT BABY BLUE RIGHT RH SIDE
Paypal   US $149.99
82-92 Camaro Firebird Passenger RH Side Front Medium Gray Seatbelt Retractor
82-92 Camaro Firebird Passenger RH Side Front Medium Gray Seatbelt Retractor
Paypal   US $44.95
NOS 1987 Pontiac Firebird Trans Am GTA Front Seat Belt Loops Saddle/Tan NOS
NOS 1987 Pontiac Firebird Trans Am GTA Front Seat Belt Loops Saddle/Tan NOS
Paypal   US $55.00
70-92 CAMARO FIREBIRD FRONT DISC BRAKE CALIPER BOLTS RH or LH
70-92 CAMARO FIREBIRD FRONT DISC BRAKE CALIPER BOLTS RH or LH
Paypal   US $8.99
1969 Camaro Firebird LH Front Floor Pan Made In US
1969 Camaro Firebird LH Front Floor Pan Made In US
Paypal   US $69.00
FIREBIRD FORMULA FRONT BUMPER CENTER SPOILER
FIREBIRD FORMULA FRONT BUMPER CENTER SPOILER
Paypal   US $99.00
FIREBIRD FRONT WIPER MOTOR
FIREBIRD FRONT WIPER MOTOR
Paypal   US $40.00
Left Driver Replacement Front Side Marker Light 98-02 Pontiac Firebird Trans Am
Left Driver Replacement Front Side Marker Light 98-02 Pontiac Firebird Trans Am
Paypal   US $15.43
Passenger Replacement Front Side Marker Light 98-02 Pontiac Firebird Trans Am
Passenger Replacement Front Side Marker Light 98-02 Pontiac Firebird Trans Am
Paypal   US $15.43
88 89 90 91 92 CAMARO FIREBIRD U JOINT U JOINTS FRONT WITH ALUMINUM DRIVESHAFT
88 89 90 91 92 CAMARO FIREBIRD U JOINT U JOINTS FRONT WITH ALUMINUM DRIVESHAFT
Paypal   US $13.95
Pontiac Firebird 67 68 69 front disc brake conversion
Pontiac Firebird 67 68 69 front disc brake conversion
Paypal   US $99.99
CONSOLE ASHTRAY FRONT GM  1993 - 2002 CAMARO FIREBIRD
CONSOLE ASHTRAY FRONT GM 1993 - 2002 CAMARO FIREBIRD
Paypal   US $25.99
FRONT SEAT HINGE COVER LH NOS GM 1993 19941995 CAMARO FIREBIRD
FRONT SEAT HINGE COVER LH NOS GM 1993 19941995 CAMARO FIREBIRD
Paypal   US $31.99
82-92 Camaro Firebird Front Lwr Power Seat Track Cover
82-92 Camaro Firebird Front Lwr Power Seat Track Cover
Paypal   US $6.95
1967-68 PONTIAC FIREBIRD CAMARO RH FRONT SEAT NEED UPHOLSTERY
1967-68 PONTIAC FIREBIRD CAMARO RH FRONT SEAT NEED UPHOLSTERY
Paypal   US $200.00
Firebird Gabriel Ultra Front Shocks - G56700
Firebird Gabriel Ultra Front Shocks - G56700
Paypal   US $45.55
Firebird Gabriel Ultra Front Shocks - G56700
Firebird Gabriel Ultra Front Shocks - G56700
Paypal   US $45.55
FRONT CONTROL ARM NUT 1993 - 2002 CAMARO FIREBIRD U 1997
FRONT CONTROL ARM NUT 1993 - 2002 CAMARO FIREBIRD U 1997
Paypal   US $6.99
FRONT SEAT AIR BAG CRASH SENSOR 1993 1994 1995 CAMARO FIREBIRD U
FRONT SEAT AIR BAG CRASH SENSOR 1993 1994 1995 CAMARO FIREBIRD U
Paypal   US $9.99
82-92 Firebird TA Front Fender Vents NOS GM PAIR
82-92 Firebird TA Front Fender Vents NOS GM PAIR
Paypal   US $105.95
82-92 CAMARO Z28 RS FIREBIRD TA 3 FRONT HEADLINER CLIPS RETAINERS
82-92 CAMARO Z28 RS FIREBIRD TA 3 FRONT HEADLINER CLIPS RETAINERS
Paypal   US $17.99
Front Disc Brake Pads Chevy Camaro SS Z28 Firebird T/A
Front Disc Brake Pads Chevy Camaro SS Z28 Firebird T/A
Paypal   US $9.99
71-78 CAMARO & FIREBIRD STANDARD FRONT SEAT BACK COVER R=L
71-78 CAMARO & FIREBIRD STANDARD FRONT SEAT BACK COVER R=L
Paypal   US $39.99
98-02 Pontiac Firebird Trans Am 5.7L LS1 OEM RH Front Side Marker Light Lamp
98-02 Pontiac Firebird Trans Am 5.7L LS1 OEM RH Front Side Marker Light Lamp
   US $22.49
70 71 72 73 OEM Firebird Trans Am Endura Nose Front Bumper Brackets
70 71 72 73 OEM Firebird Trans Am Endura Nose Front Bumper Brackets
Paypal   US $80.00
98-02 Pontiac Firebird Trans Am 5.7L LS1 OEM LH Front Side Marker Light Lamp
98-02 Pontiac Firebird Trans Am 5.7L LS1 OEM LH Front Side Marker Light Lamp
   US $29.99
LeBra Full Front End/Hood/Headlight Covers-1998-2002 Pontiac Firebird
LeBra Full Front End/Hood/Headlight Covers-1998-2002 Pontiac Firebird
Paypal   US $72.00
Powered by phpBay Pro

Check out Amazon:
Dorman 742-101 Camaro/Firebird/Astro/Safari Front Window Lift Motor Dorman 742-101 Camaro/Firebird/Astro/Safari Front Window Lift Motor
List Price: $85.98
Sale Price: $22.98

Dorman Products, Inc. is well-known as a leader in providing quality auto parts to the aftermarket. We've earned our reputation for excellence from over three decades of experience in providing automotive replacement parts, fasteners and service line products primarily for the automotive aftermarket...

Husky Liners Custom Fit Heavy Duty Front Floor Mats for Pontiac Firebird (Black) Husky Liners Custom Fit Heavy Duty Front Floor Mats for Pontiac Firebird (Black)
List Price: $92.57
Sale Price: $46.53

**Important: This product is designed to fit only certain vehicles. Please be sure to specify your year/make/model vehicle using the ‘Find Parts’ stripe at the top of the product page on our website to make sure it fits...

ACDelco 18A813A Advantage Front Brake Rotor ACDelco 18A813A Advantage Front Brake Rotor
Sale Price: $30.11

Features and BenefitsACDelco Advantage brake rotors and drums feature the fit, form and function of premium aftermarket brakes at a more economical price. The ACDelco Advantage line offers dependability, performance and great value without sacrificing important features and benefits...

Husky Liners Custom Fit Heavy Duty Rubber Front Floor Mats - Pack of 2 for Pontiac Firebird (Tan) Husky Liners Custom Fit Heavy Duty Rubber Front Floor Mats - Pack of 2 for Pontiac Firebird (Tan)
List Price: $92.57
Sale Price: $46.00

**Important: This product is designed to fit only certain vehicles. Please be sure to specify your year/make/model vehicle using the ‘Find Parts’ stripe at the top of the product page on our website to make sure it fits...

Dorman 740-886 Chevrolet Camaro/Firebird Front Driver Side Power Window Regulator Motor Dorman 740-886 Chevrolet Camaro/Firebird Front Driver Side Power Window Regulator Motor
List Price: $69.74
Sale Price: $49.43

Dorman Window Regulators have been re-engineered to improve on the original design. The latest technological advances in motors, materials and cable systems have been applied to new and previously released applications.

Dorman 740-887 Chevrolet Camaro/Firebird Front Passenger Side Power Window Regulator Motor Dorman 740-887 Chevrolet Camaro/Firebird Front Passenger Side Power Window Regulator Motor
List Price: $69.74
Sale Price: $62.16

Dorman Window Regulators have been re-engineered to improve on the original design. The latest technological advances in motors, materials and cable systems have been applied to new and previously released applications.

Husky Liners Custom Fit Heavy Duty Front Floor Mats for Pontiac Firebird (Grey) Husky Liners Custom Fit Heavy Duty Front Floor Mats for Pontiac Firebird (Grey)
List Price: $92.57
Sale Price: $46.53

**Important: This product is designed to fit only certain vehicles. Please be sure to specify your year/make/model vehicle using the ‘Find Parts’ stripe at the top of the product page on our website to make sure it fits...

ACDelco 88960088 Chevrolet/GMC Front Power Window Regulator Motor ACDelco 88960088 Chevrolet/GMC Front Power Window Regulator Motor
Sale Price: $27.42

AC Delco Window Regulator Motor is engineered to meet all the high standards set by the industry. It is known for its quality, performance and dependability and provides long, maintenance free life. This unit is put through a variety of tests under extreme and unusual conditions to ensure high quality and dependability.

ACDelco 11M24 Professional Front Side Door Window Regulator Motor Kit ACDelco 11M24 Professional Front Side Door Window Regulator Motor Kit
Sale Price: $29.44

MOTOR KIT,FRT S/D WDO REG

1998-2002 Pontiac Firebird/Trans Am Sniper Front Bumper 1998-2002 Pontiac Firebird/Trans Am Sniper Front Bumper
List Price: $335.00
Sale Price: $268.00

1998-2002 Pontiac Firebird/Trans Am Sniper Front Bumper


Here are some more information for Firebird Front:
Firebird Front

Attention, General Motors! The concept Camaro now making the rounds of U.S. auto shows is a real winner. Keep showing the car, but start making plans to get it built...now! Make no changes to the concept; in other words: keep the boardroom geeks away from the project. Yes, GM is looking at bringing back a venerable nameplate - the Chevrolet Camaro. If all goes as planned, a 2009 model Camaro is a strong possibility. Read on for additional interesting tidbits.

Back in the late 1960s, General Motors responded - albeit a little late - to the wildly successful 1964 1/2 launch of the Ford Mustang. A whole new breed of cars were on the market - pony cars - thanks to the Mustang and GM's release of the Chevrolet Camaro and the Pontiac Firebird. Indeed, Chrysler and American Motors jumped in too with the Dodge Charger, Plymouth Road Runner, and AMC Javelin competing successfully in a popular automobile segment.

Consumer tastes have changed over the years and the Camaro did not keep up them. Better put, it was GM who did not keep up with the Camaro and it, along with the Firebird, were retired after the 2002 model year. 35 years of Camaro/Firebird history came to a bitter end.

Fortunately for Camaro lovers, it may once again be the hated Mustang that rescues the Camaro. As in the 1960s, GM is witnessing Ford's big success with its retro looking Mustang and GM wants a piece of the action. Unlike GM, Ford never retired the Mustang name and, instead, gave it a complete makeover that has galvanized sales.

The Camaro making the rounds of the U.S. auto shows is a real beauty. Taking its styling cues from the '69 Camaro, the proposed '09 Camaro is expected to feature a 6.0L V8 engine paired with a 6 speed manual transmission. The wheels are 21" at the front and 22" at the back, but smaller wheels are likely to be the production standard. In addition, the Camaro's interior will hearken back to the original model's interior and include its famed twin instrument pod.

With a base V6 available, the standard Camaro may retail for just under $20,000, a highly competitive price for an awesome looking two door coupe. Now, if the powers that be within GM can be persuaded to build the car based on the concept, the Camaro will certainly give the Mustang a run for the money and keep the all new (retro) Dodge Challenger from swiping away Camaro loyalists.

Oh, to dream about big things...the Camaro is one car that enthusiasts want to go from concept to completion and soon! GM, are you hearing us?

Copyright 2006 – For additional information regarding Matt Keegan, The Article Writer, please visit his blog for wit, quips, and freelance writing tips.

Get Started with QT and Embedded FireBird

Written by:
Sergey Timoschuk,
Software Developer of Device Team, Apriorit Inc.

Content

Introduction
Setting environment
1. Install QT SDK:
2. Build QT for the work with VS 2005(2008)
3. Install Visual Studio Addon for QT
4. Install FireBird
5. Build Plug-in for IBase
Connecting to the existent database
Creating FireBird database programmatically
Database queries
Simple Select from the database.
How to call the stored procedure?
Conclusion
Useful links

Introduction

In this article we will consider questions:

  1. Installation of QT SDK, its configuration and integration with Visual Studio.
  2. Building IBase plug-in.
  3. Creating the database programmatically and setting connection with it.
  4. Also we will discuss the problem with the username and password for the database.
  5. We will consider simple queries to the database and also calling of the stored procedures.

Setting environment

Described example is based on the QT 4.5.2 LGPL.

So to set the environment use the following steps.

1. Install QT SDK:

  1. You should have required disk space (2-3 GB if you need to build all libraries and examples, 1.5 GB otherwise).
  2. Install SDK:  QTSDK 4.5.2 - http://get.qt.nokia.com/qtsdk/qt-sdk-win-opensource-2009.03.exe.
    It’s recommended not to change the default path (or you can use the same path but for example on the disk "D:").
  3. Create Environmental Variable "QTDIR" and set the path "C:Qt2009.03qt" (if the disk was not changed on step 2.

2. Build QT for the work with VS 2005(2008)

1) Start "VS 2005 Command Prompt"  (in the Start menu)

2) In the appeared console go to the folder QTDIR = "C:Qt2009.03qt"

3) Start "configure.exe" with such parameters:

configure.exe –plugin –sql -ibase

You can see details on these parameters by means of the command:

configure.exe -help

4) When the console asks: Which edition of Qt do you want to use? we choose Open Source Edition.

After that we press "y" to accept the license offer.

5) Now we should wait a bit while the files of VCProj and main Solution are being created. Finally the solution file projects.sln is created in the folder "C:Qt2009.03qt".

3. Install Visual Studio Addon for QT

1) Close all Visual Studio applications.

2) Start the installation qt-vs-addin-1.0.2.exe - http://get.qt.nokia.com/vsaddin/qt-vs-addin-1.1.2.exe.

3) Start Visual Studio and open QT options by means of the menu "QT->QT Options". Click Add and create some name, for example "QT 4.5.2". The specific name is not important but it is stored together with the project, and so the other developer can not to build the project in a proper way because of the error ("No such QT version is found on this machine" or something like this).

Specify the path to the QT folder that is for our example $(QTDIR)("C:Qt2009.03qt"). And finally choose the new created record "QT 4.5.2" as the QT Default Version.

4) There is no need to build all projects. We should build only:

  • QtCore
  • QtGUI
  • QtSQl
  • QMain

Note: Win32 static library and QT Library have different settings for "Treat wchar_t as Built-In" property. If you want to build the Win32 static library into the QT application, then you should either build QT without this option or to change the property "Treat wchar_t as Built-In Type" to "No (/Zc:wchar_t-)".

To switch off this option in QT you should do the following before the step 2:

  • Open file qmake.conf. It can be found here QTDIR/mkspecs/win32-msvc2005/qmake.conf. I worked with the Visual Studio 2005 and so used subfolder win32-msvc2005. If you work with the other version then open this file in the corresponding folder.
  • In this file we should change the flag QMAKE_CFLAGS by deleting -Zc:wchar_t-.

4. Install FireBird

Firebird can be downloaded here – FireBird - http://downloads.sourceforge.net/project/firebird/firebird-win32/2.1.3-Release/Firebird-2.1.3.18185-0_Win32.zip?use_mirror=softlayer.

5. Build Plug-in for IBase

Go to the folder $(QTDIR)srcpluginssqldriversibase and build the project in Debug and Release.

Before building change the project properties:

  • In the C/C++/General->Additional Include Directories add the path to the folder include (for example C:Program FilesFirebirdFirebird_2_1include)
  • In the Linker/General -> Additional Library Directories add the path to the folder where the libraries for FireBird are placed. (for example C:Program FilesFirebirdFirebird_2_1lib)
  • To build the IBase project we should correct the name of the linked library (Linker/Input->Additional Dependencies) from gds32_ms.lib to the fbclient_ms.lib. This library is included into the FireBird package.

Embedded Server can be downloaded here: FireBird Embedded 2.1.3 Release - http://downloads.sourceforge.net/project/firebird/firebird-win32/2.1.3-Release/Firebird-2.1.3.18185-0_Win32_embed.zip?use_mirror=softlayer

  • Rename the file fbembed.dll to the fbclient.dll.

Connecting to the existent database

Before setting the connection with database we should first load the QIBASE plug-in. If you decide to use the plug-in and load it manually, then the following code is for you (with assumption that plug-in is in the same folder with EXE file).

 



if(!pluginLoader_.isLoaded())

{

pluginLoader_.setFileName(QApplication::instance()->applicationDirPath()

+ QDir::separator() + qtIBasePluginName_);

if (!pluginLoader_.load())

{

//// Loading SQL Driver failed.;

isInitialized_ = false;

return false;

}

}

 

QObject* object = pluginLoader_.instance();

 

if (object == NULL)

{

//Loading SQL Driver Instance failed.;

 

pluginLoader_.unload();

return false;

}

 

QSqlDriverPlugin* plugin = qobject_cast<QSqlDriverPlugin*>(object);

 

if (plugin == NULL)

{

//QSqlDriverPlugin == NULL;

pluginLoader_.unload();

return false;

}

 

driver_ = plugin->create("QIBASE");

 

if (driver_ == NULL)

{

//Loading QIBASE Driver Instance failed.;

pluginLoader_.unload();

return false;

}

 

isInitialized_ = true;

 

return isInitialized_;

Now when the plug-in for working with FireBird is loaded, we can start with the setting the connection to our database.

 

connectionName_ = "Connection_1";

QSqlDatabase database;

 

//Adding database (DRIVER);

database = QSqlDatabase::addDatabase(driver_, connectionName_);

 

//Check Valid database.;

if (!database.isValid())

{

QString lastError = database.lastError().text();

//Database is not valid

return false;

}

 

//Set database configurations.;

// filePath = ":D:FireBirdAndQTdebugNew.FDB";

// userName = "Serg";

// password = 12345;

// connectionString_ = "server type=Embedded; auto_commit=True;

// auto_commit_level=4096; connection lifetime=1; DataBase="%1"";

database.setDatabaseName(filePath);

database.setUserName(userName);

database.setPassword(password);

 

QString connectionString = QString(connectionString_).arg(filePath);

database.setConnectOptions(connectionString);

 

bool result = false;

//"Openning database. Driver PTR == %d", (int)database.driver();

result = database.open();

 

if(!result)

{

QString lastError = database.lastError().text();

lastError_ = (uint)database.lastError().number();

}

I want you to pay special attention to the property QSqlDatabase of the object:

 

database.setDatabaseName(filePath);

database.setUserName(userName);

database.setPassword(password);

 

 

QString connectionString = QString(connectionString_).arg(filePath);

database.setConnectOptions(connectionString);

 

Login, password and full path to the database could be passed in the connection string, but there I faced with the following problem. When passing all mentioned settings in the connection string and not by the functions set…(), I discovered that they were not assigned to the database object.

Creating FireBird database programmatically

To create the database in the program you should perform the following:

 

bool FireBirdDatabase::Create(const QString&amp; filePath, const QString&amp;

userName, const QString&amp; password)

{

 

if (!isInitialized_)

{

Initialize();

}

 

if (QFile::exists(filePath))

{

return false;

}

 

databasePath_ = filePath;

 

QString queryString;

queryString += "CREATE DATABASE";

queryString += " '" + filePath + "'";

queryString += " USER '" + userName + "'";

queryString += " PASSWORD '" + password + "'";

queryString += " DEFAULT CHARACTER SET UNICODE_FSS";

 

ISC_STATUS_ARRAY status;

isc_db_handle databaseHandle = NULL;

isc_tr_handle transactionHandle = NULL;

 

unsigned short g_nFbDialect = SQL_DIALECT_V6;

 

if (isc_dsql_execute_immediate(status, &amp;databaseHandle, &amp;transactionHandle,

0, queryString.toStdString().c_str (), g_nFbDialect, NULL))

{

long SQLCODE=isc_sqlcode(status);

return false;

}

 

isc_commit_transaction( status, &amp;transactionHandle );

 

if (databaseHandle != NULL)

{

ISC_STATUS_ARRAY status;

isc_detach_database(status, &amp;databaseHandle);

}

 

return true;

}

Why did I choose isc_dsql_execute_immediate() method of the database creation? The answer is simple – I just didn’t manage to do it in another way :) . Some providers allow to create database as follows:

 



QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

db.setDatabaseName(":memory:");

if (!db.open())

{

QMessageBox::critical(0, qApp->tr("Cannot open database"),

qApp->tr("Unable to establish a database connection.n"

"This example needs SQLite support. Please read "

"the Qt SQL driver documentation for information how "

"to build it.nn"

"Click Cancel to exit."), QMessageBox::Cancel);

return false;

}

 

BUT in particular for this QT version and IBASE driver this method doesn’t work.

To get more detailed information you can turn to the examples from QT (QTDIRexamplessqlConnection.h).

Note: Be careful - FireBird works only with the ASCII coding. Therefore if your path (filePath) contains UNICODE symbols then the function isc_dsql_execute_immediate returns an error.

Database queries

Simple Select from the database.

 

void DatabaseModel::SelectJobs(QStringList&amp; jobs )

{

QSqlQuery query = QSqlQuery(fireBirdDatabase_.CreateQuery());

 

QString preparedString = "SELECT JOB_NAME FROM TBL_JOBS";

 

query.prepare(preparedString);

 

if (!query.exec())

{

QString err = query.lastError().text();

throw std::runtime_error("Error executing Query.");

}

 

while (query.next())

{

QSqlRecord record = query.record();

jobs.append(record.value(0).toString());

}

}

where fireBirdDatabase_.CreateQuery() looks as follows:

 

{

return QSqlQuery(QSqlDatabase::database(connectionName_));

}

How to call the stored procedure?

Let’s consider an example – the procedure to add the new record to the database.

Our procedure obtain parameters: the string with the position name, the salary value as the integer number, and also the description that is stored in the binary form (BLOB).

Our procedure returns the ID of the new record.

 

{



QByteArray description("Test description");

int salary = 1200;

jobName = "tester";

QSqlQuery query(fireBirdDatabase_.CreateQuery());

bool result = query.prepare("EXECUTE PROCEDURE SP_INSERT_JOB (?, ?, ?)");

query.addBindValue(jobName);

query.addBindValue(salary);

query.addBindValue(description);

 

if (!query.exec())

{

QString err = query.lastError().text();

throw std::runtime_error("Error executing Query.");

}

query.next();

int jobID = query.value(0).toUInt();



}

Conclusion

I hope that this article will help you to:

  • Configure QT environment for the further work.
  • Build the plug-in for the work with FireBird.
  • Connect to the existent database or create the new one programmatically.
  • Execute various requests to the firebird.

I’ve attached the test database and code to illustrate the described steps and examples.

To browse the database you can use these clients:

  • IBExpert - http://ibexpert.net/ibe/
  • FlameRobin - http://www.flamerobin.org/

To access the test database use login Serg and password 12345.

Download the source code.

Useful links

  • Firebird database - http://www.firebirdsql.org/.
  • FlameRobin (open-source administration tool) - http://www.flamerobin.org/.
  • IBExpert (administration tool, free Personal Edition download) - http://ibexpert.net/ibe/.
  • Other Firebird tools - http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_contrib_download.
  • QTSDK 4.5.2 - http://get.qt.nokia.com/qtsdk/qt-sdk-win-opensource-2009.03.exe

About the Author

Sergey Timoschuk is Software Developer of Device Team in Apriorit Inc.
Apriorit is the provider of the professional consulting and development services in the advanced software development fields.

who knows if a 1979 firebird front end would fit on a 1989 firebird???? i think that would look hott!!!! Help!

Just Say NO !!!!!!!!!!!!!!!!!!!!
But good Luck if you have the cash.

Do the GTA kit on your 89 its easy and less work !
Do a Cowl induction Hood like L-88 or 70 to 76 Shaker
Looks Great also...

Side note if you do try it, remember the 79 nose is Wider on the 89. You will need a one off Fiberglass nose made for it. fenders and hood will need modified also front of doors might need custome work to make it look better...

When you get done you might not like it... I've seen 3 versions of this tried. NONE looked very good when finished.

Here is Hurst ... compare silver to the white one.
http://images.highperformancepontiac.com/events/hppp_060400_03z+1979_2002_2002_1989_Pontiac_Trans_Am+Passenger_Side_Front_View.jpg

89
http://www.classicsandcustoms.com/list/images/X_1989_Pontiac_Firebird_Trans_Am_20th_Anniversary_Edition_305_12072006033956_16473.jpg

79-80
http://www.classicsandcustoms.com/list/images/X_1980_Pontiac_Firebird_Turbo_Trans_Am_04252008114303_19548.jpg

GTA !!!!!!!!!!!!!!!!!!!
http://www.gtasourcepage.com/89PhotoGalleryPics/meletakos89gta.jpg

79 T/A
http://www.customautorestorations.com/P1010004.JPG

PHOTO GALLERY: Cool weather graces Noble MayFest
Cloudy skies and a cool Saturday did not do much to deter participants in the 10th annual Noble MayFest at Noble Village Park. The event was hosted by White Squirrel Cruisers Car Club and Cornerstone Community Church in Noble. White Squirrel Cruisers President Robin Haerr said there were approximately 59 entries of cars, trucks and motorcycles. “It’s going well. We’re pleased with the turnout ...

Thanks for visiting!

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay
Comments (0) Trackbacks (0)

No comments yet.

Leave a comment

No trackbacks yet.