Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ilya Rabyy
  Where is Ilya Rabyy?
 Fountain Valley
 California - United States
 Ilya Rabyy
 To: Yull67
  
 
 
 Yull67
 Tags
Subject: RE: CAST Something AS M (binary) - ?
Thread ID: 143693 Message ID: 143802 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, August 31, 2007 4:33:42 PM         
   


> >
> > I tried
CAST(Something AS M NOCPTRANS)
and VFP rejected it.
> > I tried
CAST(Something AS "M NOCPTRANS")
and VFP rejected it.
>
> Hi Ilya,
>
> I wouldn't expect NOCPTRANS clause to work as a parameter to the CAST() func. :) Try without, see if you get what you expect. If you really, really need to make sure that you don't have code page translation in your field, I think that you should first create a temp table with CREATE CURSOR and use it in your SQL command.
>
> Regards,
> Yull

I don't see how... The matter is - it's a UDF collecting entries from a grid's column populated with comboboxes. That is the thing looks like
CAST(GetListEntries(lcPK) AS Whatever)

If I follow your advise, I guess I have to make a cursor TEMP (Fld1 M NOCPTRANS), shove the return from GetListEntries() into it and then SELECT &lcFlds, Fld1 FROM OtherTbl, TEMP - is it what you mean?

Regards,

Ilya

ENTIRE THREAD

CAST Something AS M (binary) - ? Posted by Ilya Rabyy @ 8/31/2007 12:04:37 AM
RE: CAST Something AS M (binary) - ? Posted by Yull67 @ 8/31/2007 2:03:34 AM
RE: CAST Something AS M (binary) - ? Posted by Borislav Borissov @ 8/31/2007 9:00:13 AM
RE: CAST Something AS M (binary) - ? Posted by Ilya Rabyy @ 8/31/2007 4:42:08 PM
RE: CAST Something AS M (binary) - ? Posted by Ilya Rabyy @ 8/31/2007 4:33:42 PM
RE: CAST Something AS M (binary) - ? Posted by Yull67 @ 8/31/2007 4:54:00 PM
RE: CAST Something AS M (binary) - ? Posted by Ilya Rabyy @ 8/31/2007 5:27:50 PM
RE: CAST Something AS M (binary) - ? Posted by Yull67 @ 8/31/2007 6:05:46 PM
RE: CAST Something AS M (binary) - ? Posted by Ilya Rabyy @ 8/31/2007 6:33:09 PM
RE: CAST Something AS M (binary) - ? Posted by Cetin Basoz @ 8/31/2007 5:57:56 PM
RE: CAST Something AS M (binary) - ? Posted by Ilya Rabyy @ 8/31/2007 6:09:57 PM
RE: CAST Something AS M (binary) - ? Posted by Cetin Basoz @ 8/31/2007 11:32:32 PM