Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old August 9th, 2005, 05:15 AM
kangZ kangZ is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 3 kangZ User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 35 m 40 sec
Reputation Power: 0
Unhappy Problems getting Data out of Dbase

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.

Reply With Quote
  #2  
Old August 9th, 2005, 06:16 AM
kangZ kangZ is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 3 kangZ User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 35 m 40 sec
Reputation Power: 0
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";

Reply With Quote
  #3  
Old August 10th, 2005, 09:13 AM
kangZ kangZ is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 3 kangZ User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 35 m 40 sec
Reputation Power: 0
Quote:
Originally Posted by kangZ
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";





SOLVED

Reply With Quote
  #4  
Old August 11th, 2005, 03:28 AM
fikret fikret is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Location: Sarajevo, Bosnia
Posts: 111 fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 5 h 32 m 19 sec
Reputation Power: 8
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Problems getting Data out of Dbase


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT