|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi, I'm new on Firebird and tryed ist out but had some Problems.
After I set up my Database and my Tables With the EMS FireBird Manager Tool (trial version) I wrote some Test Data into my Tables. I can read them without a problem with WinSQL. But ISQL and the .NET Datareader have problems and can not find any Data except in one Table. So I can make select * ..... from all tables wher is data in in WinSQL and it shows me the same like in EMS FireBird Manager. But nothing with the isql Tool from Firebird or with the .NET Interface. Can someone help me please. I'm really frustrated at the moment. |
|
#2
|
|||
|
|||
|
reboot helped a bit
after rebooting my M$ System at least ISQL selects work.
But not the Select in my code. FbCommand com = new FbCommand( " SELECT \"user\".\"userID\", \"userPermissions\".\"permissionID\" " + " FROM \"user\", \"userPermissions\"" + " WHERE \"user\".\"userLogin\" = " + "'" + userLogin + "'" + " AND \"user\".\"userID\" = \"userPermissions\".\"userID\"" , ecolineCon_); should be the same as //WINSQL COMMAND //SELECT "user"."userID" , "userPermissions"."permissionID" //FROM "user", "userPermissions" //WHERE "user"."userLogin" = ::userLogin /* 'name' */ //AND "user"."userID" ="userPermissions". "userID"; |
|
#3
|
|||
|
|||
|
Quote:
SOLVED |
|
#4
|
|||
|
|||
|
What was the problem?
-- Best regards, Fikret Hasovic http://fikret.fbtalk.net USAID TAMP Senior Programmer * Firebird Foundation member. - Join today at http://www.firebirdsql.org/ff/foundation * JEDI VCS contributor http://jedivcs.sourceforge.net/ * Firebird and Fyracle news http://www.fyracle.org |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Problems getting Data out of Dbase |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|