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!

  • Congratulations strongm 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: *

  • Users: tacs
  • Order by date
  1. tacs

    VFP and Informix

    Obviously I can't use the actual data for some of the lines, but this is the format used and non sensitive information. 'dsnname', is not the value used in the actual string. This works cSqlStr = cSqlStr + "dsn = dsnname"+; ";Driver = {Informix 3.3 32 BIT}"+; ";Host = hostname"+...
  2. tacs

    VFP and Informix

    Thanks for this Olaf The DSN name used in the string is actually that set by whom ever set up the database x years ago (not actually DSName). I have tried using DSN='' and it always takes me to a Windows screen 'Select Data Source' which has 2 tabs, the second of which shows the Data Source...
  3. tacs

    VFP and Informix

    I have recently started working with an Informix database (iSql) and need to create a new login routine from within VFP as my manager doesn't want to use ODBC which it is right now. Everything I have tried so far comes back with a Windows screen 'Select Data Source' and if I choose the data...
  4. tacs

    When SELECT doesn't select!!

    No problem Olaf. Thanks again for your help.
  5. tacs

    When SELECT doesn't select!!

    Olaf, I can't say that I am surprised that you can't recreate the problem. I have never seen it before and it sounds as though no one else has come across this either. To try to help you tie up your loose ends: The cursor that was the record source for the grid was created in the...
  6. tacs

    When SELECT doesn't select!!

    Olaf, I'm not criticising your advice, far from it, I appreciate the time and information supplied by everyone that contributes to this forum. I understand that many things can change the source of a grid. I thought I had explained that it's just a form that I can run in the IDE and as such...
  7. tacs

    When SELECT doesn't select!!

    I can understand that if you dont specify a control source for a column then you will get the first field in the table specified in the record source for the grid. However, if you put a table name in that doesn't exist (or spell it incorrectly, my own personal favourite!!) then you get an error...
  8. tacs

    When SELECT doesn't select!!

    Sorry Olaf, I didn't mean to cause more confusion that there already seems to be with this little problem. The code that was being run sat in the double click event of a column1.header1.text1 in the grid. In the IDE at design time the RECORDSOURCE of the grid is set to a cursor that was...
  9. tacs

    When SELECT doesn't select!!

    Thanks Olaf. I have no clue what makes this work, but nothing has changed in the code. The entire piece of code was picked up from the grid double click and placed in the new print button's click event. The data source for the grid is a cursor created from the table it always refused to move...
  10. tacs

    When SELECT doesn't select!!

    Just for completeness. After putting a button on the form and copying in all of the text from the double click of the grid, I replaced the double click text with : thisform.command1.click This also seems to work quite happily.
  11. tacs

    When SELECT doesn't select!!

    Well, I put a command button on the form and copied the text from the double click event into the click of the button. I paused it immediately before running the report and it worked right away. Just as a check I ran it again and the grid double click doesn't select the cursor I need for the...
  12. tacs

    When SELECT doesn't select!!

    OK, thanks again guys. I won't link the image in then. I'll try your suggestions in the morning and let you know what happens.
  13. tacs

    When SELECT doesn't select!!

    Sorry, I just read that back and I should add this. When it does the replace it doesn't use an alias. It does a SELECT then REPLACE fieldname with ....... I could deal with it if the debugger was simply out of step, it could be I suppose, but where I tried to index and here where I try to run...
  14. tacs

    When SELECT doesn't select!!

    Thanks for your posts guys. I'm not on site now until Monday so I will try out the idea of moving the control to a button away from the grid when I get back. I have taken a screen shot of the debugger which show it paused immediately after the SELECT command. You can see the data session...
  15. tacs

    When SELECT doesn't select!!

    That is totally correct, which is why I am so confused. The only table showing as selected is the first table in the session. The select command, SELECT csrNew, results in no change to what I see as the selected table and if I try to index on a field that is not in the first table (the one it...
  16. tacs

    When SELECT doesn't select!!

    Yes, there is a dbc and it is open. Not all of the tables are actually in the dbc some of them are free tables and cursors. Thanks anyway.
  17. tacs

    When SELECT doesn't select!!

    Also, I have tried running this both in the IDE and also in the EXE with the same results.
  18. tacs

    When SELECT doesn't select!!

    Thanks Olaf. First of all the form was modeless, but didn't need to be so just in case .... I made it modal, but that didn't make any difference. I have put SET STEP ON immediately after saying SELECT csrNew and run the form. As expected it stops on the vey next line and in the debugger watch...
  19. tacs

    When SELECT doesn't select!!

    Thanks Mike. Yes, the csrNew has been selected in the code, I have tried several times, and yes I can see it as one of the 16 in the data session. It's just strange, none of the tables or cursors in the datasession can be selected. The code runs through, but seems to completely ignore the...
  20. tacs

    When SELECT doesn't select!!

    Sorry, I meant to say that you can select it in the command window.

Part and Inventory Search

Back
Top