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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Pollock

  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
See more

Part and Inventory Search

Back
Top