VFP8 getnextid using cursoradapter views

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - [SingFox] VFP UserGroup Meeting Time : 6 - 9 PM Date: 4 May 2005 Place: MS Office @ Marina Bay . For More info and directions - please see http://groups.yahoo.com/group/SingFox . If You wish to attend please SMS your name to me at 9004 1089 - I have to put your name on the Roster List for MS Security Desk. warmest regards / xie xie [Bill] Tag: VFP8 getnextid using cursoradapter views Tag: 211026
  - 2
    - How to prevent DBC trigger from firing I have to write a utility that will update production tables. The tables have triggers to update a datetime changed field when the record is updated. The nature of the change I'm making is such that this trigger absolutely cannnot fire. Is there any quick and easy way to prevent record validation rules from firing? This is a production system and I can't change the DBC just for this update. The update is an automatic process, no human intervention. Tag: VFP8 getnextid using cursoradapter views Tag: 211020
  - 3
    - May letter on Visual FoxPro web site This month's letter contains a summary of some recent Visual FoxPro news as the Visual FoxPro team is busy working on future plans for Visual FoxPro to be announced next month. http://msdn.microsoft.com/vfoxpro/letters/ Ken Levy VS Data Product Manager Microsoft http://blogs.msdn.com/klevy http://msdn.microsoft.com/vfoxpro -- Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: VFP8 getnextid using cursoradapter views Tag: 211019
  - 4
    - create a help file i will appreciate if can help me, i develop visualfox 7.0 application, but i need to create a help file i dont know how. Tanks Tag: VFP8 getnextid using cursoradapter views Tag: 211018
  - 5
    - Method code swapping in VFP8 SP1 VFP8 SP1 on XP Pro SP1 I've seen this reported in other versions of VFP, but not in VFP8. After editing a form and running it, I got some odd errors. I went back into the form and found that several methods had their code swapped. The code from the Load and Init methods had been swapped, the code from the Show and Unload methods had been swapped. How's that for scary? This form has about 40 custom methods added to it and only the native methods that had code in them got swapped. The custom methods were all fine. In VFP's defense, at the time this happened, (but after the form had been saved, compiled, and run) VFP crashed due to another issue. I suspect these events are related since I've never seen this code swap problem before this. -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: VFP8 getnextid using cursoradapter views Tag: 211014
  - 6
    - RDP, Memory and VFP Hello, At a customers place, I have to develop foxpro (8.0) in a Remote Desktop session on a heavy machine, lots of memory, 2 cpu's etc.. When I' m running large queries I frequently get an error: "Not enough memory for map file", or when I look at the rushmore optimization it says; "Not enough memory to rushmore optimize table x". I tried SYS(1104) or/and sys(3050,1,large) / SYS(3050,1,small). But nothing seems to help. Sometimes it helps to log off the rdp session and start a new session. Because off security reasons it's not easy to try the query on a local machine (without RDP)... Is there anyone who knows how to solve this? TIA Gerben Kessen Tag: VFP8 getnextid using cursoradapter views Tag: 211012
  - 7
    - Multiple Detail bands in Report Writer? Not sure if that's what I need to do or not, but here's the gist... We do testing services here, using vehicles. The data is compiled at certain mileage intervals. The report goes like this... Header Detail lines showing data at each mileage interval More lines showing data another way at each mileage interval. Same as above, data another way. Same as above, data still another way. Same again, data still another way. Each of these "bands" show the mileage intervals and dates that the data was compiled. But each of these show the data in a different manner. Initially, raw data, next band a sort of summary type data, the next band a projection data, but still based at the individual mileage increments when the data was compiled, next band is a series of comments compiled at each measurement interval and finally a set of physical properties taken at each mileage interval. Right now this is done as a "manual" report in FPD2.6. I have no idea how to get this into the report writer. Can someone please help? Point me in the right direction? Thanks! Shawn Tag: VFP8 getnextid using cursoradapter views Tag: 211002
  - 8
    - shellexecute I need to display .pdf' files from within a Foxpro program. I thought that a shellexecute command was the way to go, but I can't seem to get it to work. Any help and/or sample code will be great. -- Lost in Tampa Tag: VFP8 getnextid using cursoradapter views Tag: 211000
  - 9
    - User-Defined string Functions Transact-SQL - built-in functions Fo Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL, the name and functionality of which correspond to the same built-in functions of Visual FoxPro GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string AT() Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost character RAT() Returns the numeric position of the last (rightmost) occurrence of a character string within another character string OCCURS() Returns the number of times a character expression occurs within another character expression PADL() Returns a string from an expression, padded with spaces or characters to a specified length on the left side PADR() Returns a string from an expression, padded with spaces or characters to a specified length on the right side PADC() Returns a string from an expression, padded with spaces or characters to a specified length on the both sides PROPER() Returns from a character expression a string capitalized as appropriate for proper names RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the right ARABTOROMAN() Returns the character Roman number equivalent of a specified numeric expression ROMANTOARAB() Returns the number equivalent of a specified character Roman number expression ... For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards Tag: VFP8 getnextid using cursoradapter views Tag: 210997
  - 10
    - VFP8 & Linux I am new in this subject... Is it possible to run a VFP8/application,exe/ on a workstation where the server's operating systeem is Linux? Could anyone help me? Many thanks. -- Sandor Tag: VFP8 getnextid using cursoradapter views Tag: 210987
  - 11
    - VFP8 & Linux I am new in this subject... Is it possible to run a VFP8 /application, exe/ on a Win98 workstation, where the server's operating system is Linux? Could anyone help me? Many thanks. -- Sandor Tag: VFP8 getnextid using cursoradapter views Tag: 210986
  - 12
    - Tableupdate fails - VFP8/SP1 Hi all! * Write from a local paramerized view to its basetable´s memofield IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias) llUpdated = tableupdate(1,.F.,lcAlias) * respons to user IF llUpdated = .T. wait 'Saved' nowait window ELSE TABLEREVERT(.F.,lcAlias) wait 'Not saved' nowait window ENDIF ENDIF Is the VFP-multiuser-stuff stable? User A saves to a memofield as above and receives the Saved-message. After that user B opens the same view and saves unother value to the same field and she receives the Not saved message. What can be wrong? The view is is opend shared of course. I have tried to reindex the table and recover the database as well. Best regards Christina Tag: VFP8 getnextid using cursoradapter views Tag: 210984
  - 13
    - PrintScreen direct output to printer ? Hi I am using VFP6 SP4 I want to make a command button to dump the screen or active window and direct output to printer (not copy to clipboard). when the user clicks this command button, it is the same as press key PrtSc How can I do that ? pls give me a hand thanks all Tag: VFP8 getnextid using cursoradapter views Tag: 210982
  - 14
    - Copying a Graphic to the Clipboard Anyone have a routine that will take a graphic (e.g. a .JPG file on disk) and copy it to the Windows clipboard so the user can then just paste it in a graphics program like Paint Shop or Photo Shop? Thanks. Charlie Parker Tag: VFP8 getnextid using cursoradapter views Tag: 210977
  - 15
    - RUN will not work - requires working dir? I have an application on my machine that is basically an icon on the desktop with the following for the target P:\psw.exe. If I take properties on the icon, under "start in" it has p:\. If I double click the icon on the desktop, it works as expected. On one of my VFP forms, I have a command button with the following code and the program will not run (it generates an error specific to the program) RUN /N "P:\psw.exe" Any ideas how I can trouble shoot this, or modify the run command so it has a "start in" that emulates what it is expecting? Thanks, Dan Tag: VFP8 getnextid using cursoradapter views Tag: 210968
  - 16
    - C0000005 upon vfp exe exit after responding to .net events I am getting a dreaded C000005 at address 79221bd8 after running a simple vfp exe that opens a simple .net form and responds to an simple event. The event is being handled fine by VFP, but upon exit the windows error is displayed. What is strange is that when this simple app runs in the VFP IDE it works just fine. No errors. Running it standalone produces the error. Does anyone here have some experience/sample code in responding to a vb.net dll's events in a VFP executable? I would sure appreciate some help here. Again the code is working just fine; .net dll is being created and .net form is running in new thread, I am implementing an eventhandler in VFP correctly since the event fired by the .net form is being responded to by VFP. It just blows when exiting back to Win XP. Thanks. SJT Tag: VFP8 getnextid using cursoradapter views Tag: 210960
  - 17
    - Report. Page X Out of Y by Groups.VFP9.0 Hi, I want to be able to print "Page 1 out of 4" for every group on the report so that every group will start from page 1. Another word, I need page totals for every group. Note: VFP9.0 Thanks, Eugene. Tag: VFP8 getnextid using cursoradapter views Tag: 210959
  - 18
    - Hiding the top level form Hello and thanks in advance for the help. If you have an app with a top level form where the other forms are "In top level form" and Desktop = .t., How do you hide the top level form when the user goes into a subform? Does the parent object of the lower level form point to the top level form? Thanks, Jeff Tag: VFP8 getnextid using cursoradapter views Tag: 210956
  - 19
    - SQL: Group By error Hi, I'm new to FoxPro and am converting from version 5 to version 8. I'm getting this error: SQL: Group By clause is missing or invalid. The offending code is: SELECT statepmt.state_code, strecon.total ; FROM statepmt, strecon ; WHERE statepmt.yyyy_mm = w_yyyy_mm AND ; statepmt.state_code = strecon.name ; GROUP BY statepmt.state_code ; INTO CURSOR statots It works fine in version 5. I'd appreciate any comments. Thanks, Jim. Tag: VFP8 getnextid using cursoradapter views Tag: 210948
  - 20
    - DOUBLE-BYTE PROBLEM HI ALL I TRY TO USE WEB SERVICE FOLLOW THE SAMPLE CODE IN VFP 9 HELP. BUT I WERE CONFUSED WTIH HOW TO TRANSFER CHINESE BIG5 FIELD AND CONTENTS PROPERLY. I FOLLOWED THE CODE BELOW Walkthrough: Creating XML Web Services with Visual FoxPro and made northwind!customer's filed into chinese include content but failed Can somebody help me ? Tag: VFP8 getnextid using cursoradapter views Tag: 210939
  - 21
    - vb.net usercontrol used in a foxpro 9 app Hi, In VS6.0 it was simple to create an active-x control in VB and then use it as a ole object in Visual Foxpro. I'm trying to figure out how i can pass values from visual foxpro to a vb control and then return completed values. Can anyone shed some light on this, and/or provide examples. Thanks GG Tag: VFP8 getnextid using cursoradapter views Tag: 210936
  - 22
    - data migration Hi friends am exporting vfp data to sql server and am using DTS to export. my question is is there any option to export all tables at once rather than doing one at a time? Thanks -- cheers Tag: VFP8 getnextid using cursoradapter views Tag: 210931
  - 23
    - indexing problem How do you index a table which has a field which may be positive, negative or zero? The problem is a secondary field is also required which is a character field. Let's say field1 is the numeric field and field2 is the character field. Using the following command to create the index, does not produce the desired results: INDEX ON STR(field1,FSIZE("field1")+field2 TAG myindex For example, I would see the following numbers in a browse form when looking at the field1 column : 0 1 2 3 4 -1 -2 -3 -4 But, the desired response is: -4 -3 -2 -1 0 1 2 3 4 I'm sure other people must have come across this problem -- any ideas? Thanks, -- E. Myron I have a table containing two field called myvals which can contain numbers from -99 to +100. When I index the table using the following command, everything is fine: INDEX ON myvals TAG numindex If I index using the following command, the result is incorrect: INDEX ON STR(myvals) TAG strindex The problem is that I have to use a string because I am combining two fields in order to get a secondary -- To reply, change "invalid" to "net" Tag: VFP8 getnextid using cursoradapter views Tag: 210928
  - 24
    - SQL Problem I have a problem (VFP6) in getting a summed amount which I need for a report. In simplified form, because there are other related tables, the code reads:- Select tenants.lastname,tenants.tenantref,more fields, tenacc.item,tenacc.debit,tenacc.credit,sum(tenacc.debit) as sumdebit,sum(tenacc.credit) as sumcredit; From tenants inner join tenacc; On tenants.tenantref=tenacc.tenantref; order by tenants.tenantref; Where (tenacc.item='Due' OR tenacc.item='Received'; INTO cursor rentsa The problem is that the summed fields include all debits and credits for tenantref, ignoring the Where line which is intended to restrict them. I would like to define the summed fields as sum(tenacc.debit) for (tenacc.item='Due' OR tenacc.item='Received') but SQL does not accept a FOR clause. I have also tried using the summing ability of a report format, but cannot seem to get it to work Help would be much appreciated. -- Tim Hobson Tag: VFP8 getnextid using cursoradapter views Tag: 210917
  - 25
    - Timer events... when? ...in Fri pm duh mode. Timer events fire between lines of code or between procs? Also there are some issues with users setting focus on other non-VFP processes while timers are enabled, I seem to remember. Some refresher remarks about that'd be good, too. TIA. -Lew Tag: VFP8 getnextid using cursoradapter views Tag: 210904
- Next
  - 1
    - - How to Save Target As.. ? I am trying to automate IE6 to downolad a bunch of documets (.tif, .fax files). Is there a way to execute "Save Target as" within IE object? For instance, I have a link that looks like this: https://www.whatever.com/viewfiles.jsp?fileid=999&name=FILE+NAME+.TIF and I need to download this file to a specific folder with a new file name: c:\TifFiles\_999FileName.tif If I use URLDownloadToFile, I get a blank page since viewfiles.jsp is preventing me from getting the file directly. However, if I use Navigate and then ExecWB(saveas), I am prompted with a dialog to Open/Save/Cancel from Navigate followed by Save As (filename)dialog from ExecWB. With this, I get the ability to download the file but how do I stop the prompts? Ideally, what I am looking for is something like URLDownloadToFile(with ability to provide source url and destination file name) that would work like Navigate->ExecWB(saveas) without the prompts... Is this the right group to post this on? Tag: VFP8 getnextid using cursoradapter views Tag: 210902
  - 2
    - VFP 9: report not displaying 4-digit century This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C54CB6.42EE9CE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable All, I've been pulling my hair out over this! I have one report that = displays 4-digit year while another only displays two. I've fiddled = with VFP default date settings and still won't display 4-digit century. Suggestions please. Thanks ------=_NextPart_000_0006_01C54CB6.42EE9CE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DVerdana size=3D2>All,</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>I've been pulling my hair out over = this!  I=20 have one report that displays 4-digit year while another only displays=20 two.  I've fiddled with VFP default date settings and still won't = display=20 4-digit century.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Suggestions please.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Thanks</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C54CB6.42EE9CE0-- Tag: VFP8 getnextid using cursoradapter views Tag: 210895
  - 3
    - Record does not unlock Hi I have an application made in FPW 26, using tables .DBFs. An application process locks a record and when finishes, unlocks it. Randomly, the record is not unlocked and other users performing the same process stay waiting indefinetly and they have to kill the application. Even though when the process who locks the record finishes and the user closes the application with all tables closed, the record remains locked and other user remain waiting. What could be the problem? How can I solve it? Thanks in advance Francisco Heker Tag: VFP8 getnextid using cursoradapter views Tag: 210890
  - 4
    - Servoy & Firebird learning curve compared to FoxPro Goldmine 7.0 (CRM) is moving away from xBase, will ship with Open Source SQL DBMS called Firebird (similar to Interbase) as alternative to MS SQL Server version of their product. I'm not much of a programmer, and the only programming language I have ever come close to mastering is/was FoxPro (VFP 6). I have thought of learning Filemaker Pro but since Goldmine is probably going to be my CRM of choice and version 7 will nolonger use dBase I'm faced with learning more about Firebird and wondering what I would use to access the underlying data in addition to or outside of Goldmine. I lean towards FoxPro only because I'm familiar with it already. Interested in opinions / comparisons of FoxPro and Firebird, and also a FoxPro users perspective on Servoy as an RAD tool. John "J.J." Jackson Tag: VFP8 getnextid using cursoradapter views Tag: 210881
  - 5
    - store procedure return result I got a SP to do the insert update, if the insert statment is completed, i would like to return a variable to indicated whether the insert is sucess or not. How can I do this ?? Thanks a lot . Tag: VFP8 getnextid using cursoradapter views Tag: 210873
  - 6
    - Foxisapi won't launch COM application Here is my situation: VFP 6.0, XP PRO. http://localhost/common/Foxisapi.dll/RESET & STATUS work properly COM server is out-of-process exe COM server can be loaded directly from Fox with: o = create("bulkm.x2") ? o.testServer() && This works But when I try to launch it from within IE I get "page cannot be displayed" http://localhost/common/foxisapi.dll/bulkm.x2.testServer In the event log I get: The HTTP server encountered an unhandled exception while processing the ISAPI Application 'foxisapi + 0x1E96 + 0xD8CF25C5' It must be a permissions problem. So within the component services I have set: The COM permissions on "My computer" are set to Allow Access and Launch for the IUSR account Under DCOM config the COM server is set to use the defaults for security I am thinking that maybe it is the permissions on the common directory, because Foxisapi writes a file to that directory. I have set the directory to "web sharing" with read/write permissions. I don't know what else I can do. Can anyone help? Tag: VFP8 getnextid using cursoradapter views Tag: 210867
  - 7
    - How to find the VFP version used to compile a prg and to build a com dll? Hi all, Is there a way I can find the VFP version used to compile a fxp and to build a COM+ dll? Thankx. Nadee. Tag: VFP8 getnextid using cursoradapter views Tag: 210866
  - 8
    - Outlook Read Email Does Not Run The Form I tried posting this to the Outlook forum with no responses.... I have a custom Email form I have designed with a button on it. However, I notice that when I double click on a form in my inbox the custom form is loaded so that I can read the Email on the custom form. But, the button won't work unless I then click Form, Run this form. Isn't there a way that I can make the button work automatically when the user reads their Email so that they can just click the button rather than click Form, Run this form and then click the button. I'm guessing that maybe Microsoft did this so that scripts won't run but I'm wondering if there is an easy way to activate that button. Thanks Tag: VFP8 getnextid using cursoradapter views Tag: 210863
  - 9
    - Showing Microsoft Outlook's Inbox Hello - I am trying to find a way to show Outlook's Inbox. I already know how to use FindWindow to flip over to Outlook but it just flips over to whatever window is present which could be the calendar, tasks, etc. I'm wondering if there is a way to make it show the Inbox. Thanks. Tag: VFP8 getnextid using cursoradapter views Tag: 210862
  - 10
    - Images and VFP9 I am in the process of moving from VFP7 to VFP9. One problem I have encountered is graphic images on my forms look like crap in 9 when running on Windows 2000 Terminal Server. Granted W2K only supports up to 256 colors, but my VFP7 images looked OK. Any suggestions? I have already tried SET PALETTE OFF, but this does nothing. BMP's look the best, and GIF's look really horrible. All the images are 256. Tag: VFP8 getnextid using cursoradapter views Tag: 210859
  - 11
    - HyperlinkButton opens hyperlink minimized I am creating a small form with Hyperlinks to sites our intranet uses. The difficulty I am having is finding out how to have the hyper link open and take focus. When the user clicks the link, I would like it to open IE full screen so they can see what they clicked on. right now it is minimized to the start bar. I looked at the code ont he sample hyperlink.scx, and theirs doe the same thing. Dan Tag: VFP8 getnextid using cursoradapter views Tag: 210858
  - 12
    - VFP Linked Sql Server deleted records I created a linked server to vfp from SQL server. I have no problem querying records with one exception. I can't seem to filter out deleted records. I'm using the VFP 8 Oledb driver. Tag: VFP8 getnextid using cursoradapter views Tag: 210854
  - 13
    - foxexpress dos Does anyone have a copy foxexpress for dos (2.6 or 2.7) to post (or sell)? The f1tech does not sell it any more and I can't find it any where on the internet. Tag: VFP8 getnextid using cursoradapter views Tag: 210843
  - 14
    - _ShellExecute Error 5? I have one user (XP SP2) of an application that gets a return value of 5 from shellexecute. The program is attempting to run an "FDF" file. The file association appears to be okay. In fact if I click on the selected file it open in Acrobat Reader as expected. The documentation for shellexecute mentions the following: 2 = Bad Association (for example, invalid URL) 29 = Failure to load application 30 = Application is busy 31 = No application association No mention of 5. Anyone have any idea what 5 represents? Dave Tag: VFP8 getnextid using cursoradapter views Tag: 210842
  - 15
    - textbox date format I have picked my brain to bits and I can't figure this out. Maybe someone can help me. There is a grid and underneath this grid there is a textbox that is called txtSearch. So users type the word they are searching for and hit Seek. Now when you have ordered the grid by last name the txtSearch is fine. When you click on the Date column, the txtSearch now has / / indicating a date format. When you hit on the Last name column one more time, the / / do not disappear. I can not get it to. Do you know where this formatting is set and why I can't get rid of the two forward slashes? I just want to be able to say something like txtSearch.Clear or something. Thanks in Advance. Tag: VFP8 getnextid using cursoradapter views Tag: 210838
  - 16
    - Another question that doesn't really belong here but since you are my people.... Hello and thanks in advance for the help. In WinXP (or most other Win OS's) you can go to START->SETTINGS->PRINTERS right click on the printer and choose "SET AS DEFAULT" Is there a way to do this in code from VFP? Thanks again, Jeff Tag: VFP8 getnextid using cursoradapter views Tag: 210829
  - 17
    - Put Object on _Screen in front In VFP 8, I created a container class and added it to the screen with _screen.AddObject to use it as a Status Bar. But it is possible to drag VFP windows over it. In the Original VFP-Status Bar you can't. So my question: Is it possible to put the container in Front ? I tried Z-Order but this didn't help or is the Screen and the object on it always in the back ? Thanks -Florian Tag: VFP8 getnextid using cursoradapter views Tag: 210826
  - 18
    - vcx to prg How can I save a vcx file as a prg programatically without using the class browser. Is it possible? thanks in advance Dave Tag: VFP8 getnextid using cursoradapter views Tag: 210824
  - 19
    - create failure in select command Hi, need some help... Have following code in the init-method of a form: **************************************** * Ladda kunderz **************************************** SELECT DISTINCT a.kunkey ; FROM qpkart a ; WHERE a.kunkey != "Z Extra" ; AND a.kunkey != "Z OddStuff"; AND a.kunkey != " "; INTO ARRAY kunderz ORDER BY a.kunkey artkzx = ' ' m.kund = ' ' m.artnrz = 0 m.memo1 = '' m.memo2 = '' m.memo3 = '' m.sign = '' m.datum = 0 **************************************** When I try to execute the form with the DO command I get the error-message: "KUNDERZ" is not an array. I have been reading the VFP help file and see following sentence: "If an array does not exist and the SQL SELECT Statement returns one or more records, the command creates an array. An existing array is re-created to accommodate the query results." Can't see what I have done wrong.... Patrik Tag: VFP8 getnextid using cursoradapter views Tag: 210821
  - 20
    - how could i add controls to my grid columns ? hey i am finding very difficult to add controls like button or checkbox in the column. I am using vfp9, eventhough i have seen the example control.sct in sample i could not do it... so please let me know the detail process to add it... -- Message posted via http://www.dbmonster.com Tag: VFP8 getnextid using cursoradapter views Tag: 210818
  - 21
    - Barcode - scanning from com3 Hi, I have a barcode scanner (SF51 manufacturer Intermec) It work's with bluetooth and is installed on com3. To let it works in windows you can youse Hyperteminal and set the incomming port to com3. To use it in notepad you have to youse the accessibility from windows and set the serial port to com3. on this way he works like a wedge scanner. the data from the scanner is than in QWERTY but in belgium we all work with AZERTY (this is could be a bug in windows). is it possible to use the scanner in fox using the com3 using MScomm. Does someone has an example. Thanks in advance Tag: VFP8 getnextid using cursoradapter views Tag: 210815
  - 22
    - Import (not append) CSV file? Import (not append) CSV file? I know how to Append from a CSV comma delimited file to an existing database, but that requires 1) determining how many fields are needed 2) making sure each field is long enough to accomodate whatever length data may be found in the CSV file etc. 3) creating the table 4) Doing the actual append Is there a a) way within Visual FoxPro 6 itself or b) free third party utility that will quickly convert a CSV file to a FoxPro .dbf with 1)the proper number of fields 2) minimum required field length so as to avoid any data truncation for each field? John "J.J." Jackson Tag: VFP8 getnextid using cursoradapter views Tag: 210803
  - 23
    - BeforeNavigate2 won't fire for HTTP Post I am using the "Microsoft Web Brower" control (shdocvw.dll version 6.0.2900.2180) on a VFP 8 form. The BeforeNavigate2 event fires fine for any links I place in the HTML - but posting a form with a submit button will not fire it. I have been able to put an HTML form button with an onclick() that navigates (and fires the event), but I want to use submit so the same HTML works in both VFP and in a C++ environment too. Yes, to my great disappointment, the HTTP Post works in C++. Has anyone gotten an HTTP Post to fire the BeforeNavigate2 event in VFP? Thanks, gracious dudes and dudettes ... - Sean Tag: VFP8 getnextid using cursoradapter views Tag: 210802
  - 24
    - Question about TableValidate Hello ! What does ( Set TableValidate to 4 ) do? I dont find any documentation about using the 4 in that command Thanks Eliseo Negrin Tag: VFP8 getnextid using cursoradapter views Tag: 210795
  - 25
    - clipper and vfp filelocking ignored ! Hi, Can somebody confirm this or has a testing environment with Clipper and Vfp8. Open a table in vfp8. place a lock on the table. en try to change/add a record with Clipper. Clipper can alter and add records on the locked table in Vfp ?!? Is this normal ! I can only test it with a program (3th party) made in Clipper and Vfp8. So maybe there is something wrong with the 3th party program and not with the way Clipper handle vfp tables. Kind regards and thanks in advance. christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: VFP8 getnextid using cursoradapter views Tag: 210791

We are having some multi-user issues having changed our system over to use
cursoradapters (native and SQL). The file which controls the next id for
each table is accessed via a cursoradapter. Unfortunately requery on this
file fails if someone else has updated that file and hasn't yet committed
their change i.e. they are in the middle of a BEGIN/END TRANSACTION. Other
than avoiding getting the next id inside a transaction and requerying inside
an endless loop until successful, I can't think of a way round this. I toyed
with autoincrement fields but we have a lot of parent/child tables where we
need to know the parent id for the child records, so I've abandoned that
idea. We also access the data via ODBC in Crystal so again I think there is
a problem with autoincrement fields.

Has anyone got any other suggestions?

Thanks,
Bernie

Top

Re: VFP8 getnextid using cursoradapter views by Anders

Anders
Wed May 04 13:01:33 CDT 2005

VFPODBC hasn't got a clue about AutIncrement fields. It hasn't been updated
since VFP6. VFPOLEDB replaces it since VFP7.
-Anders

"Bernie Beattie" <BernieBeattie@discussions.microsoft.com> wrote in message
news:70EE94E3-70FA-44A3-B177-08EB20D4982B@microsoft.com...
> We are having some multi-user issues having changed our system over to use
> cursoradapters (native and SQL). The file which controls the next id for
> each table is accessed via a cursoradapter. Unfortunately requery on this
> file fails if someone else has updated that file and hasn't yet committed
> their change i.e. they are in the middle of a BEGIN/END TRANSACTION.
Other
> than avoiding getting the next id inside a transaction and requerying
inside
> an endless loop until successful, I can't think of a way round this. I
toyed
> with autoincrement fields but we have a lot of parent/child tables where
we
> need to know the parent id for the child records, so I've abandoned that
> idea. We also access the data via ODBC in Crystal so again I think there
is
> a problem with autoincrement fields.
>
> Has anyone got any other suggestions?
>
> Thanks,
> Bernie

Top