Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Pollock

    Textmerge failing in VFP 9 SP2

    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...
  2. Pollock

    Textmerge failing in VFP 9 SP2

    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.
  3. Pollock

    Textmerge failing in VFP 9 SP2

    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...
  4. Pollock

    oracle not returning any results when trying to create remote view

    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
  5. Pollock

    oracle not returning any results when trying to create remote view

    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...
  6. Pollock

    Combo box displaying year value aligned to right

    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
  7. Pollock

    Combo box displaying year value aligned to right

    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.
  8. Pollock

    Optimizing Data Import

    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.
  9. Pollock

    CHR() function in VFP 9.0

    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?
  10. Pollock

    CHR() function in VFP 9.0

    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
  11. Pollock

    CHR() function in VFP 9.0

    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?
  12. Pollock

    CHR() function in VFP 9.0

    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...
  13. Pollock

    Complex Multiple Sort

    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...
  14. Pollock

    Complex Multiple Sort

    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.
  15. Pollock

    Complex Multiple Sort

    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...
    • Pollock
    • Thread
    • Replies: 5
    • Forum: PHP
  16. Pollock

    Word 2002 and csv merge data

    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
  17. Pollock

    Word 2002 and csv merge data

    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...
  18. Pollock

    Multi Sort Issue

    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.
  19. Pollock

    Multi Sort Issue

    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...
    • Pollock
    • Thread
    • Replies: 3
    • Forum: PHP
  20. Pollock

    btrieve/N version 5.10 dos exporting from

    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

Part and Inventory Search

Back
Top