	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

11/03/2009 at 03:30AM PST, ID: 24866686 | Points: 500

	[x] Attachment Details

Cast convert access for boolean and string unlike sql server with delphi

Asked by ISIGest in Microsoft Access Database, Delphi Programming, Delphi Database

Tags: ACCESS CAST CONVER DELPHI BOOLEAN STRING

Hi, I try to use an Access database with Delphi.
When I try to create a particular query qith casting of a specified column with "EMPTY" initial value
in a Delphi DataSet the value is not real.

My query is like this for sample:
"SELECT CBool(False) AS myBoolValue, IIF(myTest1 = myTest2, 'A', IIF(myTest1 = myTest3, 'B', 'C')) AS myStringValue FROM myTable"

The result in Access is Ok but in Delphi the fields detail are ambiguos.
For myBoolValue the field definition is "SmallInt"
For myStringValue the field definition is "WideString" with a 255 lenght.

How I can retrieve a correct value like myBoolValue = TBooleanField and myStringValue = TStringField with length 1?

Thanks to all and sorry for my english.

View the Solution FREE for 30 Days

20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625

1. Geert_Gr...58,458
2. rfwoolf26,820
3. senad23,195
4. 8080_...9,214
5. developm...8,900
6. NickUpson8,400
7. aikimark8,375
8. Johnjces6,540
9. FactorB6,500
10. angelIII5,540
11. MerijnB5,250
12. kretzsch...4,200
13. tipsybroom4,000
13. rrjegan174,000
15. epasquier3,368
16. SteveBay3,200
17. Hypo3,000
18. pcelba2,500
19. acperkins2,400
20. pivar2,000
20. EddieShip...2,000
20. tbsgadi2,000
20. carrzkiss2,000
20. JimU2,000
20. sdstuber2,000
20. bokist2,000
20. Limbeck2,000
20. grant3002,000
20. PaulKeating2,000
20. bschepp2,000
20. dankangr2,000
20. udayakum...2,000
20. momi_sa...2,000
20. dominik-j...2,000
20. reynaldio2,000
20. dprochow...2,000
20. tankergoblin2,000
20. abhvp2,000
20. twocandles2,000
20. delphibegi...2,000
20. irishbuddha2,000
20. JonasMal...2,000

1. Geert_Gr...95,569
2. rfwoolf74,320
3. developm...60,874
4. kretzsch...60,331
5. ziolko35,565
6. SteveBay33,395
7. NickUpson29,757
8. mnasman27,110
9. angelIII25,185
10. senad23,695
11. aikimark22,818
12. TheRealL...20,752
13. Johnjces20,130
14. dinilud18,298
15. mikelittlew...17,736
16. emoreau16,735
17. ciuly15,175
18. Workshop...14,869
19. EddieShip...12,820
20. calinutz12,000
21. MerijnB11,881
22. FactorB11,275
23. TimCottee10,824
24. mokule10,800
25. acperkins10,290