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"+...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.