inserting new record

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
    - about font size of vfp 9.0 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C4F81D.55EC3520 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hi,All, I just compiled my vfp8 project and found a strange problem, Although my = label font size in every form is not changed(I set them all to 10),it = seems that font size 10 in vfp9.0 is more large than in vfp8?=20 Why?=20 B.Regards Chuen ------=_NextPart_000_0010_01C4F81D.55EC3520 Content-Type: text/html; charset="gb2312" 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=3Dgb2312"> <META content=3D"MSHTML 6.00.3790.218" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT size=3D2>Hi,All,</FONT></DIV> <DIV><FONT size=3D2>I just compiled my vfp8 project and found a strange = problem,=20 Although my label font size in every form is not changed(I set them all = to=20 10),it seems that font size 10 in vfp9.0 is more large than in = vfp8?=20 </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Why? </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>B.Regards</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Chuen</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0010_01C4F81D.55EC3520-- Tag: inserting new record Tag: 205742
  - 2
    - gibberish when printing in landscape VFP9 I have a very simple report, no calculations, no variables. Just simple fields. No report listeners. If I have paper orientation set to landscape and reportbehavior set to 90, the report is filled with gibberish. If portrait mode or reportbehavior is 80, it works fine. Obviously I have a workaround, since I'm not using report listeners, but I thought I'd ask whether others have seen this. I reported it already. Tag: inserting new record Tag: 205736
  - 3
    - printers Hello, I am wondering if anyone else who has created full applications in FoxPro has come up with the dilemma of how many possible ways can an envelope be fed through a printer. I am the programmer of a billing software built in Visual FoxPro. I have a feature where people can print envelopes addressed to their clients. I have a report strategicly built so that the return address and clients address are placed in the positions where once an envlope is fed there envelope comes out correct. There are three different types of HP printers at the office that I can take into account, but what about the other brands? Is there a proceedure I can use that can give me how the specific invoice takes in envelopes? Or do I have to figure out all possible ways an envelope can be fed through a printer? If this is the case can someone direct me to the correct place to look this up? I have been unsuccesful so far. Tag: inserting new record Tag: 205727
  - 4
    - firing the foxcode i've noticed that not only if we type SPACEBAR, but also typing the closing bracket ) will invoke intellisense. If one looks at the source code in XSource (in the FoxCode.prg), & places some code (preferably a messagebox in the DefaultScript() method, this will get displayed if you type ) Now, i want to know if we can control what characters invoke the foxcode. I don't want to be limited with only SPACEBAR & Closing Brackets. I a few other such key characters to invoke the intellisense (foxcode). Any ideas, any one??? Tag: inserting new record Tag: 205719
  - 5
    - new item under Options->File Locations is it possible to put in a new item in the listbox displayed under Options->File Locations I'd like to setup some development tools & want to plug the configurations of the files in here I've had a look at the xsource files, but could'nt find any code related to this Options screen. Tag: inserting new record Tag: 205718
  - 6
    - debugger problem in VFP9 I hate to quibble, but... In the Trace window, if you hover the mouse pointer over a variable or field, you get a ToolTip window showing the value of that variable. A very useful feature! But new to VFP9, if the value is a string, what's shown does not include the string delimiters, ie quotation marks. That makes it impossible to differentiate between 12345 and "12345". And it's difficult to tell between "ABC" and "ABC ". Tag: inserting new record Tag: 205717
  - 7
    - End Program What code ends a program like END in VB? Tag: inserting new record Tag: 205716
  - 8
    - Serial communication -> HOW ? Hi there, I need to somehow link a PC, via a serial port, to a weighting scale. I'm using Visual FoxPro 7 and I really don't know how to do that (I have tried some FOPEN (COM1) but it didn't work) Any ideas? Please... Daniel Tag: inserting new record Tag: 205707
  - 9
    - Tableupdate with Oracle (ODBC) Whenever I try to update an Oracle table through VFP remote view I have error message "Update conflict". Looking on internet I found one post that it is known VFP error related to the way how VFP sends fields of type varchar to Oracle (Rpad). Looks preaty catastrofic cause it eliminatas VFP as frontend with Oracle database. Did anybody knows more about it or found a workaround? Many thanks Tag: inserting new record Tag: 205702
  - 10
    - Connect to SQL server I would greatly appreciate a sample of the syntax required to connect from VFP 6 to a SQL server - either one on my own machine or one that resides on another machine that I can access by IP address. TIA. -S- Tag: inserting new record Tag: 205700
  - 11
    - location of db in de I'm playing around with different scenarios, and found this. In this app, the database consists solely of a connection and remote views, and is located in a subfolder of the project folder called data\. The database is included in the build. Forms are built with the data\ database in their data environment. At runtime, I open the database (no path, because it's included). I was concerned that the forms would not be able to locate their data, since the data\ folder does not exist at this time (I renamed the original to prevent confusion). Yet the forms seem to work fine. Can anyone elucidate? Is this behavior documented? Furthermore, I put a button on a form to display DBC(), and it shows c:\... runtime folder\data\databasename.dbc, even though the data\ folder and databasename.dbc do not exist on disk. (They could be temp files somewhere, but that's not what is shown.) Any help explaining this as a general and reliable rule would be appreciated. Tag: inserting new record Tag: 205698
  - 12
    - multiuser problem Hi, I am using VFP6 SP4 and develope an application In the multiuser environment. The form's datasession is 2-Private Data Session In the init event of the form, have the following environment setting set exclusive off open database Mydata shared set multilock on select mytable = CURSORSETPROP('Buffering', 5, 'mytable') users access to the same form (same table), got the error message " File acces is denied " Does anything wroing here ? Please give suggestions thank your very much Tag: inserting new record Tag: 205691
  - 13
    - Update Word links Hi foxpro experts, Once again I turn to you for some advise :) I have some Word documents that have linked objects, something like this : {LINK Word.Document.8 X:\\Path\Document.doc \a \f O \p}. Word stores a path to there objects, but once I copy them to a new place, the path is broken, and you have to update them. You can do this by hand ofcourse, but I would like to do it from Foxpro. I found a forum that where someone was able to make a macro to solve this issue, but I don't know enough about macro's to turn it into Foxpro code. I know how to go through "Story's" in Word, but not how to update the fields in there. Does anybody have a foxpro example on this or some help ? the forum is at : http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=wrd&Number=261488&page=&view=&sb=&o=&vc=1#Post261488 thanks very much ! Xavier, CPS Tag: inserting new record Tag: 205688
  - 14
    - Change of Paper size programatiically Hi I am using VFP6.0 with Windows XP for a system with Multi-USer I got a report using a Paper Size - Letter. But on some computer the paper size will change depending on the setting of the computer Is there any ways to set the paper size of the report before REPORT FORM Regards, Hughs Man Tag: inserting new record Tag: 205687
  - 15
    - Memory variables Vs Table buffering I learnt foxpro from an old foxbase programmer. I have only used up to VFP6. Ever since I collect memory variables from my input forms and update the tables field by field using the memvars. What benefit am I loosing by not using table buffering other than having to write more code(which I don't mind!)? How can I use table buffering when I need to do more than one record in a table (as in accounting entries)? Tag: inserting new record Tag: 205685
  - 16
    - How can I get the list of files of a directory with the correct case of letters How can I get the list of files of a directory with the correct case of letters as they really appear and not in upper case as ADIR returns them. Demetrios, Greece Tag: inserting new record Tag: 205683
  - 17
    - intellisense custom script Hi friends i've following intellisense script . when i type rk then it turns to "&& Rajani on 10/01/05". It saving lot of time for me when i write comments. ************* LPARAMETER oFoxCode Local lcRetval, lcCase,lccentury lccentury="SET CENTURY "+set('CENTURY ') SET CENTURY OFF oFoxcode.valuetype = 'V' && we want to return a value lcCase = oFoxCode.Case If empty(alltrim(lcCase)) lcCase = oFoxCode.DefaultCase && if not take default foxpro case endif lcRetval = '&' + '&' +'~' +' Rajani on ' + dtoc(date()) &lccentury && reset century Return lcRetval ********* abv code works beautifully without any problem. i am wondering if it is possible when i type my keyword(i.e. rk) on new line i want **Rajani on 10/01/05 if it is on a existing line then "&& Rajani on 10/01/05". any ideas on this will be great. Thanks -- cheers Tag: inserting new record Tag: 205679
  - 18
    - Recordlocking VFP8-SP1 Struggling with multiuserenvironment... A textbox with myView.myField (buffermode 3) as controlsource B user 1 writes Hallo to the editbox and clicks in another texbox - fires the first textbox´s valid-code: SET REPROCESS TO 3 SECONDS lcAlias = 'myView' SELECT (lcAlias) LOCK(lcAlias) tableupdate(2,.F.,lcAlias) && returns T UNLOCK ALL C user 2 on workstation 2 can see Hallo in his textbox D user 2 can do the same ("Hallo again") as B above && no error is reported E User 1 can´t se Hallo again If I replace LOCK(), UNLOCK with tableupdate(2,.F.,lcAlias) && returns T Select tblComp1 (the views sourcetable!!!!!!!!) skip 1 everything works fine! but this can´t be the right way... What am I missing???? Best regards Christina Tag: inserting new record Tag: 205673
  - 19
    - VFP web services I would like to set up an extremely basic web service application, just to get going. I only want an example that reads and updates a single field in a free table over internet. What would be the easiest way to achieve this - I don't have the time (or energy) to study hundreds of pages of web technology, and I would like to do it as much as possible within VFP 9.0. So - what's your suggestion? Tag: inserting new record Tag: 205661
  - 20
    - Data driving a class Hi, I am attempting to data drive code that can contain several methods by creating a table 'script_def' with two fields:- * script_name c(10) * exec_txt m - contains code to create the class. The test program below selects the appropriate record, creates the class and calls a method. MESSAGEBOX confirms that the correct record is selected and that test_script.prg contains the text from the correct record. However the code from the record that was selected the first time is executed - the .fxp appears to be in memory. Attempting to compile test_script.prg or delete test_script.fxp causes an error 'outstanding references exist' Any help in getting this to work (or a better way to do it) would be appreciated. TIA, John Pugh Adelaide, South Australia * Test data driving a class IF NOT USED('script_def') USE script_def IN 0 ENDIF SELECT script_def LOCATE FOR script_def.script_name='two' MESSAGEBOX(script_def.script_name) SET SAFETY OFF =STRTOFILE(script_def.exec_txt,'test_script.prg',0) SET SAFETY ON MESSAGEBOX(script_def.exec_txt) LOCAL o_test o_test = NEWOBJECT("test_class",'test_script.prg','') =o_test.test_method() RELEASE o_test RETURN *************Code in record one of script_def********************************* * Test class for data driving DEFINE CLASS test_class AS CUSTOM PROCEDURE test_2 MESSAGEBOX('test_method called from rec 1' ) ENDPROC PROCEDURE test_method =THIS.test_2() ENDPROC ENDDEFINE Tag: inserting new record Tag: 205656
  - 21
    - Product Purchase Help Its been a few years since Foxpro 2.0, Borland C++ 3.1, VB 5.0, Codebase 2.5 etc ... been off on other development tangents in the RS6000 world ... now have a client that needs some ACCESS database work ... I have been using ACCESS 2000 and not liking it very much ... ASP looks interesting ... but Im having no luck in narrowing down a dev tool to go forward with What am I looking for ... something current that I can create applets for distribution that don't require additional licencing on the users part. I have several Access databases that are 5 to 100MB that need to have multiple user access which will be deployed on Win2K Pro Serverless peer 2 peer machines Foxro used to have a licence free engine which could be packaged up with an application EXE as did VB ... What products would I need to do this today? there appear to be several flavours of Visual studio that claim the ability to develope in Foxpro, CSharp or VB Or am I better off getting a Visual Foxpro or VBasic I downloaded the free ASP webmatrix and played with SQL on a test database however the moment I attempted to connect to a 100M databas it crashed Thanx in advance Tag: inserting new record Tag: 205636
  - 22
    - Tableupdate() retuns T but acts as F - vfp8/SP1 Two users runing an VFP-app on workstation A and workstation B conected to a LAN; 1 User A enter a textbox based on myView.myField 2 User B modifies the same textbox/field 2B User B leaves the TEXTBOX and it´s valid fires (lcSuccess = tableupdate(1,.F.,myView) && returns T) 2C User B don´t leave the RECORD in myView 3 User A can´t see the modification made by B. If user B leaves the record directly after the modifing everything works just fine. But if user B don´t leave the specific record - user A can´t see the modification. And an updateconflikt occurs. myView is optimistic rowbuffered, parameterized and contains one record only. Exclusive is set off. What´s wrong? Any ideas would be very appreciated. Best reards Christina Tag: inserting new record Tag: 205626
  - 23
    - VFP 6: Large and Small Fonts I have read various posts about how large and small fonts affect Fox2 apps. How does it apply to VFP? I think I have a case of it. The symptoms: On one system, text is truncated in labels and command button captions. The form is the correct size, but the fonts are too big. How do I find out which font type is in use and the appropriate scaling factor? Sincerely, Gene Wirchenko Tag: inserting new record Tag: 205625
  - 24
    - EventHandler() or....? Hello, I'm in the process of writing an IE automation interface and was wondering if EventHandler() is still the preferred way to go. I know that Drew Speedy has used BindEvents() extensively, but I don't know if it provides similar (or superior) capabilities regarding attaching event code to an automation server. Any thoughts/suggestions will be appreciated. Thanks. -- William Fields MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ Software will always be better when written at 105 decibels. -Whil Hentzen Tag: inserting new record Tag: 205622
  - 25
    - c0000029 VFP8. This is a new one on me. This line of code causes this error: TRY IF (UPPER(SUBSTR(JUSTSTEM(DBF()),4,4) <> 'ZOOT' .AND. glVar glVar is undefined, and instead of jumping to the CATCH statement like it should, it crashes with c0000029. Tag: inserting new record Tag: 205614
- Next
  - 1
    - is not an object Hi, on the thirth line I get an error llcallform is not an object ?! Does somebody know why and how to avoid. or Howelse can I check if something is an object then Type() ? in a forms.destroy llcallform = thisform.callform IF TYPE("llcallform") = "O" .and. .not. ISNULL("llcallform") llcallform.datform = "" ENDIF regards thanks in advance christophe Tag: inserting new record Tag: 205604
  - 2
    - VFP7 cursoradapter tableupdate write order I have a situation where the order records are written (shown via audit triggers) is a bit odd. Basically I have code which updates 3 files via separate cursoradapters (buffermodeoverride=5) in one transaction. The cursoradapters can be Native or SQL Server. Cursoradapter 1 is scanned and updated 1 record at a time using tableupdate(.F.,.F.). Cursoradapter 2 is scanned and updated 1 record at a time using tableupdate(.F.,.F.). Cursoradapter 3 has a single record updated using tableupdate(.F.,.F.) Transaction ends The order the records are committed is as follows: All Cursoradapter 1 records except the last one updated. All Cursoradapter 2 records except the last one updated. Cursoradapter 3 record. Last Cursoradapter 1 record. Last Cursoradapter 2 record. Is there any way of getting the last 2 record updates committed before the Cursoradapter 3 record as it looks really odd in our audit and is bound to raise questions later? Thanks for any help. Bernie Tag: inserting new record Tag: 205601
  - 3
    - HOWTO: Know VFP version from an .EXE, thanks to Rick Bean. Once again, this is a code I borrowed from this newsgroup to be posted at www.PortalFox.com, to support VFP communities in spanish language, thanks to Rick Bean... --- HOWTO: Know VFP version from an .EXE --- --- Obtener la version con que fue compilado un EXE de VFP --- http://www.panoramabox.com/GoPub.aspx?IdObj=2410 --------------------------- Espartaco Palma SysOp www.PortalFox.com Mexico Tag: inserting new record Tag: 205592
  - 4
    - =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Continuing spreading the VFP knwoledge, here's a great code about Automating MS-Office with VFP. --- HOWTO: Inser Tables in a Word document --- http://www.panoramabox.com/GoPub.aspx?IdObj=2363 As usual, the site is in spanish, but the code is in Universal Language (VFP). HTH -------------------------- Esparta Palma SysOp www.PortalFox.com Mexico Tag: inserting new record Tag: 205590
  - 5
    - VFP database stability What's the VFP 8 database stability? I tried (long time ago) to work on i'ts database in version 4.0 and and it was terrible (constant damages and inconsistency) - since then I work on plain dbf. Is it in version 8 any better? And btw what about fpt files in this version (fpt files often loses their record links with dbf's). Jader Tag: inserting new record Tag: 205589
  - 6
    - Report Engine Error: Not enough system resources Hello, I am running Visual DBASE 5.5 on a new machine that was just installed with WinXP. The software runs on other machines, but for some reason when I try to runit on this newly configured machine, I get the following error: "Report Engine Error: Not enough system resources". I get it when I try to print a report with the built-in Crystal report tool. Does anyone have any idea as to why I am getting this error? Thanks, Eddy. Tag: inserting new record Tag: 205585
  - 7
    - New Method Why is it after I define a new method: ie, GetRecord that Foxpro dies when I assign this method as follows: THISFORM.GetRecord ( and the moment I enter the ( I get the following error: Fatal Error Exception Code=C0000005. This Method has LPARAMETERS and I am simply trying to pass them. This is VFP7 with SP2 and thats as good as it gets. If I paste GetRecord ("Delete") it works fine, as long as I don't do this within the Foxpro environment... Am I missing some important update? Thanks for your help Tag: inserting new record Tag: 205584
  - 8
    - Hiding main foxpro window Hi I am new to foxpro and am having a problem with the way it executes. In the program I call a form using a do form command and then a read events command right after it. I have compiled this and my form comes up with the data I want on it but theres a MicroSoft Visual Foxprow window behind it that I don't want to see. I assume its the window executing my code until the read events command. How can I hide this window? Thanks and cheers Jerry Tag: inserting new record Tag: 205573
  - 9
    - Unable to find an API Can anyone tell me why I'm getting the following error when I try to compile my program? Program c:\source\vbpf\prgs\procedures.prg has the following errors: Unknown _WFINDTITL - Undefined Unknown _WHTOHWND - Undefined I have this line of code in my main program SET LIBRARY TO SYS(2004) + "FOXTOOLS.FLL" ADDITIVE I have this procedure in a different program PROCEDURE TileVertically LOCAL lnhWnd * Get the Active Form's window handle lnhWnd = _WhTohWnd(_WFindTitl(_SCREEN.ActiveForm.Caption)) * Get the form's parent window lnhWnd = otile.GetParentWindow(lnhWnd) otile.TileVertical(lnhWnd) ENDPROC Tag: inserting new record Tag: 205566
  - 10
    - check if filename is legal Hi, Is there a way in Foxpro to check if a filename the user entered is legal before creating it ? thanks ! Xavier Tag: inserting new record Tag: 205554
  - 11
    - outlook class with MDI form with pageframe Hi, Can anyone show me the code to create a pull down menu with following :- - outlook class at left hand side - mdi form with pageframe at right hand side - on click of outlook class button the mdi form change accordingly ? Regards Hoe Tag: inserting new record Tag: 205549
  - 12
    - OLE error code 0x80020006: Unknown name All, I have a VFP7 application that manipulates the Outlook Inbox - searches for incoming emails and does some processing to them. One of my clients has just started receiving "OLE error code 0x80020006: Unknown name" on this line... m.FINDCNAME = UPPER(PADR(ThisForm.oItem.SenderName, LEN(cName))) Any clues? Thanks, Brian Tag: inserting new record Tag: 205547
  - 13
    - sql cursor Hi, SQLEXEC(nConnect,'select * from mytbl') I read user guide that the result will be stored into cursor SQLRESULT. But when I call 'SELECT SQLRESULT', an error 'alias not exist' shown. What am I missing ? Regards Hoe Tag: inserting new record Tag: 205544
  - 14
    - Hidden/protected object test function? Is there an easy way to test if an object is hidden or protected? I'm grabbing a likely property, BASECLASS, and using pemstatus(....,2). Just wondering if there's anything more direct. -Lew Tag: inserting new record Tag: 205541
  - 15
    - VFP table lookup on a PDA Hi, I've got a fun new project, where people in the warehouse want to be able to key in a stockcode on a PDA and return data from from our central VFP tables about current stock levels and stock location over a wireless LAN connection. PDAs will be Windows Mobile based. I realise that native VFP apps won't run on these, but there are still a few different approaches to this - various web based ones, .NET apps, etc. I'm not sure which would be best, easiest or cheapest. (got .NET through MSDN as an option, but never had time to try it out seriously.) Is anyone running a similar app? Any pointers would be very much appreciated. Cheers, Neil Tag: inserting new record Tag: 205539
  - 16
    - distributing DLL Hi friends I've created a DLL in vfp8.i want to distribute to some software vendors . my question is do i need to distribute vfp runtime files also along with my DLL? i tried using my DLL in VB on a machine which has no foxpro s/w and got runtime errors(like activex objects cant.....etc.,) but it worked fine when i copied vfp runtime files to the folder where my DLL exist. could u guys tell how you u normally distribute a DLL created in vfp. Thanks -- cheers Tag: inserting new record Tag: 205531
  - 17
    - EXE size differs when I rebuild project. I have a project. I built the EXE about 2-3 weeks ago. This morning I build it again, and the EXE it produces is a couple hundred bytes larger. Nothing has changed, the project is kept in sourcesafe and I did a get latest into a clean directory. What would cause the EXE to be different in size when rebuilding it a few weeks later? I rebuilt it in the same directory structure, but my environment changed in that I have more mapped drives. I can't think of anything else that might have changed. Tag: inserting new record Tag: 205529
  - 18
    - Comma Seperated String I was just wondering if there was a built in VFP function for converting a Comma Seperated String variable into an array. Or if there was any other function that dealt with a Comma Seperated String. I could make my own functions but if they already exist I would rather use those. -- Altman VFP8 SP1 Tag: inserting new record Tag: 205523
  - 19
    - EditBox with .NULL. value Using VFP 6.0, I have an editbox on a form and everytime the control source, which is tied to a field in a table, is .NULL. I can not change/add any information in the editbox. Is this a bug with VFP6.0 and if so, is there a way around this? Tag: inserting new record Tag: 205522
  - 20
    - Field Names Hi! I would like to just extract or print the field names, type of field and size from a table. Is this possible? Thanks Tag: inserting new record Tag: 205519
  - 21
    - Temp files Hello and thanks in advance for the help. I have the following lines in my config.fpw tmpfiles=c:\foxtemp sortwork=c:\foxtemp progwork=c:\foxtemp editwork=c:\foxtemp My applications (EXE's) reside on a folder on the user's PC and access data on network drives. The applications are started from the folder on the local PC. It seems that all of the temporary files which result from SELECT * FROM WHATEVER INTO CURSOR MYCURSOR READWRITE and any resulting index files are placed in the startup directory. Is there a configuration setting to tell VFP where to put these files? Thanks, Jeff Tag: inserting new record Tag: 205513
  - 22
    - test ignore Tag: inserting new record Tag: 205508
  - 23
    - Treeview Control Does anyone know how to change font/color of nodes in the treeview control? Is that even possible? If not, is there a better control to use instead? Many Thanks Shahriar Tag: inserting new record Tag: 205501
  - 24
    - how to get all remote cursors connection in current data session? Hello all, Continuing my problem regarding connection to MSSQL, here is the latest progress (and question) about my effort to find the solution. Because my thread 'A lot of lockings and connections to SQL Server. Is it normal or bad?' in this ng didn't get any reply, I decided to cross post in microsoft.public.sqlserver.programming (I put the discussion in this post for your convenience in case you're willing to read). Anyway after giving more thought about the problem, here is what I found: I found out that each time I run any form in my apps (the form is child window, in-top-level, private-data-session), after I close the form, there were two or three external connections still intact. I can easily 'kill' those external connections by running following break.prg. *!* Break.PRG ON ERROR * FOR i = 1 TO 200 SQLDISCONNECT(i) ENDFOR ON ERROR *!* end of break.prg Regardless whether I kill those connections or not, after I run another form, there would be other two or three external connections added (and other locking as well - although I don't understand what kind of locking MSSQL do). All connections belong to one apps would be immediatelly close if I closed the apps. Yes, I know that this would be my own fault and I should learn more. That's why i already purchase a copy of Client Server with VFP6, and will certainly read the book cover-to-cover. Anyway, what I need now is a quick-and-dirty fix to my problem. What I have in mind is to explicitly close the connection with SQLDISCONNECT( ) on the Destroy event of each form. I can easily put that in my baseclass form and it will affect all forms in my apps. Problem: Anybody knows how to get (and to traverse) all cursors (remote views and cursor from SPT) in current (active) data session? I cannot run break.prg on Destroy event, because that would kill other connections needed by other window. I'm looking forward to hearing from you! TIA, Willianto Following is the discussion I mentioned above: My original post: --------------------------------------------------------- Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (created with Microsoft Visual FoxPro 8.0 SP1, connect with SQL Server thru ODBC) interact with SQL Server. I found out that on some parts of my apps (where there are lots of traverse and calculation), the number of locks on the SQL Server could go up to 700 and the external connection could go up to 15 or 20. And I tested that on my box (that means; I run my apps on the server and no workstation connect to the server). Whilst the apps so far running fine, it's never been really tested to the max. The traffic are quite low and the concurrent user has never exceed eight users. Yet, looking at the numbers, I'm afraid that there something that I don't do effectively. My Questions: 1. Is the number normal? 2. Anybody here can give me advices on C/S programming, I mean just a quick thumb rules what should and what, like should I make a connection, get the data, and disconnect immediately. Or should I share all SPT in one connection?, or any other rule what should and shouldn't? Thanks in advance Willianto ====================================== Following is the reply from Louis --------------------------------------------------------- This is the open question of all times. Without looking at the code, the best that can be said is that you might be fine, or you might have written a terrible app (something we all have done at one time or another :) Lots of locks are fine, as long as you don't have lots of users contending for those locks. You say you have 8 users, is that all you are planning for? If everyone is happy, it might be fine. Bottom line is that you need to get some literature and read up on design, internals, optimization, etc before you can decide if your application is well written, and experience is a must. Without being able to magically aquire this (and it takes a while and sadly we learn from failure!) I would suggest that you take this statement: > Whilst the apps so far running fine, it's never been really tested to > the max. Define what max means and test for it. If it works fine under max conditions, then your application is fine. ====================================== And my reply again: --------------------------------------------------------- Hi Louis: Thanks for your reply. > best that can be said is that you might be fine, or you might have > written a terrible app (something we all have done at one time or > another :) Lots of .. [skipped] Looks like my case is the second one :( As I stated in my post, the application runs fine, but it runs with a very minimum load. That's because the company using my apps is a machinery trading company. The activity is very low. To give you a clue how 'low' is that; they only have to create less than 10 invoices a day. Actually, that's the best numbers they got for years (that means less than ten sales a day - but, hey, the profit of selling one machine could cover three months expenditure!). Anyway, what I did is I backup the database, call up some of my fellow, line up eight computers, and massively attack the system with all the apps feature (purchasing, receive goods, stock preview, stock opname, delivery order, customer order, etc...). After an hour we manage to hang the server which by then, got about 350,000 locking and 80,000 external connections :( So, using SQL Server as a backend is not _that_ easy... Oh well, at least I know for sure that the problem won't appear in my client for a near future. Regards, Willianto Tag: inserting new record Tag: 205492
  - 25
    - how to post a message in my application to the users i want to display a message to the users of my application a message when certain administrative tasks are to be done (esp indexing of the files, or forcing the clients to log out). How can i display these messages to the users of my application? Tag: inserting new record Tag: 205490

Is it possible to insert a new record within a table? I don't have a way to
sort. It's just a list that needs to stay in a certain order. I'm using vfp8.
Thanks
Sherry

Top

Re: inserting new record by borisb

borisb
Tue Jan 11 09:29:11 CST 2005

sherry wrote:
> Is it possible to insert a new record within a table? I don't have a way to
> sort. It's just a list that needs to stay in a certain order. I'm using vfp8.
> Thanks
> Sherry
Why not index the table?
anyway, In the table has no indexes You must opened it exclusive & use
INSERT BLANK.

USE MyTable EXCLUSIVE
GO 15
INSERT BLANK
REPLACE Field1 WITH 111 ...

But the Table must have NO indexes no metter if You use order or not

Top

Re: inserting new record by Anders

Anders
Tue Jan 11 15:05:44 CST 2005

Use an index or display as items in a Listbox or combobox with Sorted = .T.,
or use a query cursor with an appropiate ORDER BY clause.

-Anders

"sherry" <sherry@discussions.microsoft.com> wrote in message
news:CC9D447E-36B0-4C69-8837-794538BC5939@microsoft.com...
> Is it possible to insert a new record within a table? I don't have a way
to
> sort. It's just a list that needs to stay in a certain order. I'm using
vfp8.
> Thanks
> Sherry

Top