I understand what you're saying Mike and it makes sense, but it still gives me 0...
I found another solution, I put my sql statement in a cursor and I do a Select nameOfCursor after.
With that I can use RECNO() to have the row.
So thanks Mike for trying to help.
TheBlainer
Hi,
I have a little problem and it seems so simple that it doesn't work. I have a grid that has a Sql statement as RecordSource and the data returned inside my grid is fine.
I have a button on my form that need to interact with the grid. So I need the ActiveRow of the grid and for that I...
I want to mention that this program is old and was first made in dBASE 4 and was transfered to foxpro 2 later.
It should be because of that if it was made this way and has been passed over the years.
TheBlainer
First : Thanks Mike for your reply
Second : indeed I didn't have to USE the table. I only put the file in the select and there's no more problem with workaeras.
Third : When I first learnt VFP longtime ago, we showed me this way of using table and I tought that it was the right way to do it. I...
Hi
I have a form with a listbox that contains a SQL statement. In the init of the form, there's the code
Thisform.lsttHERMOS.RowSourceType = 3
SELECT 107
USE N:\APPS\PAL_NOVA SHARED
thisform.lstthermos.RowSource = "SELECT NOM FROM " + DBF(107) + " INTO CURSOR mylist"
THISFORM.LSTthermos.Requery...
Indeed Tamar, I could have used a new form property or like Olaf said a tag in the combobox that would have been even better.
Usually I use form properties instead of public, but I think I want it to do it fast, so i used bad public variable for that.
I will change it to a tag because i only...
Thanks for your help you all
But only Olaf gave me an idea, because all your answers didn't really help me. So i used the debugger and after some tests. It gave me this.
To reolve my problem, I did :
- In the beginning of the init of the form, I create a variable
PUBLIC DONTDOIT
DONTDOIT =...
Hi
I have a form with a combobox with 8 elements in it.
Now, in the interactivechange of this combobox, it calls a form(named frmMoreInfo) for more information on the choice.
I want frmMoreInfo to be called anytime I click on one of the choice in the combobox EVEN if it's the same item that...
Thanks jrbbldr!
and also Mike and Olaf to make his answer better!
I declared a local variable called LTITLE in the function calling my REPORT FORM and put this name in one textbox on my report and it's working ^^
Thanks again.
TheBlainer
Hi
I'm trying to pass a variable that is a string in my code to my report, but I saw that we can't do that with REPORT FORM.
So I was wondering if there's a way to do that, because it must be possible with some trick. I created a variable on my report, but I don't know how to assign my value to...
Thanks Craig for your response!
I had little difficulties to make them work, but now it's working great on my computer : Subversion and tortoiseSVN.
I will have to install them on the server now.
TheBlainer
Hi,
In the company I work for, we thought that it would be helpful to have a Source control software. Because there are more programmers in the company now.
On MSDN, it says what is it, how to enable it and how to use it. But it doesn't say what software can be added to VFP.
I saw...
Actually, I can open my choixass.dbf with vfp7.
If I rename the file to why.dbf, I was able to see it. After, I renamed it to choixass.dbf and the problem still happen.
It contains no special characters.
I think I will let the problem there because it's no big deal. I still can see and use...
I just realized that the problem only occur when I double-click my choixass.dbf and open it with FoxPro.
If I open FoxPro and after write this in the Command Window
USE g:\choixass.dbf
BROWSE
I can see my table without any problem.
This weird problem only happens with this specific table...
jrbbldr,
Well, I use to open it on a network drive, but I realized that even if I copied it on my C:, it does the same problem.
Buuuut, I created a simple form that can do MODIFY STRUCTURE AND BROWSE my choixass.dbf like that :
http://www.freeimagehosting.net/cc815
It's working like a...
Thank you so much Olaf, I don't know what would I have done without this functionality.
When I clicked on Intellisense Manager (I didn't know that it was that doing the "autocomplete"), a popup appeared and told me that the foxcode.dbf was missing. It also allowed me to restore it by clicking...
Now another problem happened :
The "autocomplete" isn't working anymore when I'm coding. I mean that when I write thisform and after I put a dot after, nothing happen. So I don't have my list of controls to choose. It's like in earlier version of FoxPro.
I search all over the options and I...
danfreeman,
My supersivor (who is the network administrator) didn't change anything and this is definitely something wrong on my computer, because we did some tests :
- He logged on his computer with my username (that's working)
- He logged himself on my computer and opened my choixass.dbf...
You were right DSummZZZ about the .tmp file hidden somewhere.
Because what I have done is that I uninstalled Visual FoxPro and reinstalled it right away. But it did nothing.
So I uninstalled it once again and went to the appdata/roaming and appdata/local and deleted all directory and files...
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.