New topic: Problem with RecordSet
<http://forums.realsoftware.com/viewtopic.php?t=45574> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message Grant Post subject: Problem with RecordSetPosted: Wed Oct 10, 2012 7:41 am Joined: Sun Jan 22, 2006 2:37 am Posts: 312 Hi, I am using a PostgreSQL database and getting a recordset. This code used to work on another database but now is not. RetailUSPrice = RS.Field("retailprice_US").CurrencyValue For some reason there is just 0.0000 in the variable RetailUSPrice which is setup as currency type. I stopped in the debugger and checked out the contents of the recordset and there is data in the field retailprice_US itself, but for some reason this part of the code RS.Field("retailprice_US").CurrencyValue does not read it. Am I going mad or is there something simple I am not doing here as this used to work. Its strange. Hope someone can help. Grant Top npalardy Post subject: Re: Problem with RecordSetPosted: Wed Oct 10, 2012 9:30 am Real Software Engineer Joined: Sat Dec 24, 2005 8:18 pm Posts: 7464 Location: Canada, Alberta, Near Red Deer What kind of column is it in the database ? That might be important to know as a value thats a string in the DB might not be autoconverted to a Currency _________________ My web site Great White Software RBLibrary.com REALbasic learning Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
