Search results for query: *

I did finally come up with a similair solution, as it seems quite a few kind of errors can set the _text to -1. My solution was to isolate code that could generate error. Prior to code execution, store the file handle contained in _text to a variable, and right after, check to see if _text was...

I am setting the _text value via SET TEXTMERGE TO (filename). And it is a consistant failure. This is the second work around I have had to come up with.

I am using textmerge in an application. In vfp 8 it works fine. I recompile the application in vfp 9 SP2, and during any process when I am using set textmerge, if a macro substituted command like "use database!remoteview" fails, the textmerge loses connection to file and no new entries are...

Odbc Connection works fine to the database as I can do other things with it. Its just trying to create an empty remote view copy of the table is where the error is occuring. Note if the oracle table has data, it returns an empty view but when the table is empty it throws up this error

Ok, last week this was working fine now its not. I am creating a remote view from an oracle 10g. server. "CREATE SQL VIEW TMPVUE REMOTE CONNECTION REMOTECONNECTION AS SELECT * FROM "+tblname when I go to execute this command I get error "No result set has been returned by the server." It...

The alignment is set to left, but problem seems to be that foxpro is converting the numeric to string when it puts it in the list and the string is being padded with spaces. These spaces are forcing the number to be partially hidden

Ok, this one is a puzzle. I create a cursor of distinct years from a table. I make the combo box rowsource the cursor field and the rowsourcetype is alias. When the form comes up the year is aligned to the right so only the first two numbers show. I need it aligned to left so full year shows.

I have a set of foxpro tables, and I am trying to optimize for speed the import of the data either into Oracle or SQL server. The tables I have contain up to 1 million records and have a size of 1 to 1.5 Gig. What I am looking for is the fastest method for importing them into a RDMS.

Ok, dumped the output to a file and look at both, they appear to be identical. yet when i use sys(15) to modify the string, it delivers different output in vfp 6 as opposed to vfp 9. Anybody have an idea why?

ok, if it then not that command, has sys(15) changed in anyway, as those are the only two functions that i use in this procedure

Ok, I tried what you said, and it does look the same, but i was looking at them in step by step debug mode and it displayed 2 totally different sets of results?

Hello, just upgraded from VFP 6 to 9 today and have come across something really wierd. The following code enc_str = '' for i=255 to 1 step -1 enc_str=enc_str + chr(i) endfor Returns a totally different result when run in VFP 9.0 then when it runs in VFP 6.0. Would anybody know the cause...

With regards to database, it is mysql... Basically what I am looking for goes something like this Select date1, date2,character1 from table table1 order by either date2 or character1 but for the 30 most current date1 records but there is no date range for date1 I just want the 30 most...

The dates that initially ordered by are not chosen so a where clause would not work, basically the initial select uses " order by date1 next 30" so I don't have to worry about how far apart the dates are, as I only want the 30 most current and they could be two days apart or 6 months.

I have a data base which contains 2 "date" fields and a character fields( actually about 30 or so other fields, but they do not relate to the problem). Problem I am running into is I need to pull only the first 30 most current date records based on date1 but then display them to the user order...

The first field in the datasource does not begin with an I. The fields are comma delimited, enclosed in double quotes and terminated by a return character

I have a program at a clients creates a valid CSV formatted data file which is used to produce form letters use Word mail merge feature. The problem is that when using word 2002 it says there is a problem connecting to it, that possible the header is corrupt or that there is no data even though...

Ok, the word date was just an example, it is called something entirely different. The problem i have is sorting in that format does not put the list in alphabetical order. It puts it in date the alpha order, and what i want is the last 40 based on date in alpha order.

I have a mysql database which has a structure similair to this date, lastname, givenname,middlename. problem is i need to take the forty or so most current items in the database based on date, and then i need to sort them by lastname, givenname, middlename.. I can get the first part with...

They Structure of the data is store in what looks like .def files. So I know exact layout of each file. But what would I do from there