This is a problem re-visited I have a better understanding but still am struggling with this issue.
I have two forms, the first is a data entry form named "Contacts." The second named "Change" is a form with a grid that shows all the contacts which is read only. I am trying to select a name in...
I have a grid in a form that reflects all of my reports. I need to be able to doubleclick on the first field in the grid which is text1 under column1 in the grid. I have placed a DO FORM in it's doubleclick event and it does start the correct entry form however I am trying to figure out how to...
I can make numbers all day but does anyone know a way to generate a bank of numbers? My sales office makes sales recipts in batches of 25. they keep track of these and will issue them to us if I can just make them show up in a foxpro application. I have tried resetting the autoinc but I still...
I have an account that wants a Sql2000 backend. I have used VFP only in the past. I want to know if I am starting from the ground up should I, A. design it and upsize it? or B. design tables in Sql2000 and link to it from VFP9. Either way how will I get the resulting tables on the customers Sql...
I have a table called "report" and I am trying to reset the autoincrement value for the coming of a new year I did get some valuable advice from the forum so I made this statement;
ALTER TABLE REPORT ALTER COLUMN report_num i AUTOINC NEXTVALUE 1 STEP 1
and for all my work I got this error...
I am experimenting with an autoincrement field instead of the "nextid" method. I can figure out how to make the prefix number of 2004 indicating records for this year. This is esay to roll over to 2005 but how do I start over at 0001 in the autoincriment field? VFP8 is the version I am using.
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.