Finding the beginning of the result set

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
    - Newbee Questions Hi I am fairly new with Visual Foxpro V6.0 having done most of my programming in C++, VB and delphi. I am quite comfortable with VFP and the language but am having trouble with GUI side of things. I wish to have a richtext box that allows the user to change font, font size and colour I see that there there is an example that comes with foxpro in the foundation classes under text formating where it makes the desired changes to the active control but I can't see how the connection between the font toolbar and the active control is made. I have encountered this connection type problem on many of the example's that I have looked at. On the RTF control how is the text printed I have had a lot of trouble controling what I want to print in foxpro there just not seem to be simple calls to print dialogs and print type statements. Any help would be greatly appreciated. Warren warrenjw@austarnet.com.au Tag: Finding the beginning of the result set Tag: 196146
  - 2
    - CursorAdapter, Parameters sql command not working I use cursoradapter builder to build a class and compile it to a datacls.exe file. I issue the command : odatacls = NEWOBJECT( "mtn08", "Datacls", "Datacls.exe" ) odatacls.selectcmd = 'select * from mtn08 where code = ?lcmyvar' lcmyvar="ST" odatacls.cursorfill() to query a parameters sql results, the Error message show as : Microsoft OLE DB Provider for SQL Server : No Value given for one or more required parameters. How to pass the parameters into the query? Tag: Finding the beginning of the result set Tag: 196144
  - 3
    - Questions about _supermover1 in VFP class library Hello, I am trying to use the supermover from the VFP class library but I can't seem to find a way to activate it. I drop an instance of the class on my form, set up the required SQL cursor as the data, and run the form. The data does successfully get loaded on the source listbox, but everything appears grey, including the 2 listboxes, the data in the source box, and even the add and remove command boxes. I check "enabled" and it is set to .T. But I can't figure out why it's still not activated. Anybody tried using this class and can show me what I'm doing wrong? Thank you. -- jw Tag: Finding the beginning of the result set Tag: 196139
  - 4
    - Databases I have been advised to issue a set default to stmt to change the path of "training" data, that is a copy of the "live" data that a user can train and learn with. Issuing a new set default to, such as set default to c:\MyApp\Train does not change the reference in the database of the form and the form continues to use the table referenced in the form. What am I missing? Tia Tag: Finding the beginning of the result set Tag: 196136
  - 5
    - Databases I have been advised to issue a set default to stmt to change the path of "training" data, that is a copy of the "live" data that a user can train and learn with. Issuing a new set default to, such as set default to c:\MyApp\Train does not change the reference in the database of the form and the form continues to use the table referenced in the form. What am I missing? TIA Tag: Finding the beginning of the result set Tag: 196134
  - 6
    - Databases I am not able to change the "database" in a form by issuing the statement "set default to c:\MyApp\Train" When I do issue the statement, the form continues to display the original database such as c:\MyApp. Running the form continues to use the table that is part of the database that was in use when the forms DE was use at the time the tables were added to the form. Is there another way to change the forms database, or am I missing something? TIA Tag: Finding the beginning of the result set Tag: 196133
  - 7
    - Command to be continued on to the next line Hi All, If I have a long line of command which I want to continue on the next line, what combination of characters do I give at the end of the first line? Thanks. Tag: Finding the beginning of the result set Tag: 196130
  - 8
    - Questions about moving items between list boxes Hi All, I have this list boxes controls that I copied from the moverlists class in "Solution" of VFP6.0. I have the following 2 problems when moving items between the list boxes. 1. It seems I can only display multi columns for the two list boxes by setting RowSourceType to 2 or above. Setting RowSourceType to 0 or 1 makes the listbox to display only 1 column. Since I need to clear the listboxes often so I'd prefer to set RowSourcetype=0. If I do that is it still possible to set them to display multi columns? 2. If I specified RowSourceType to 6 for both listboxes, The code SCAN List.AddItem(table.field) ENDSCAN fills both (source and destination) boxes instead of only the source listbox. Anyone knows why I am doing wrong here? I am using VFP6.0 sp5. Thanks for any inputs. -- jw Tag: Finding the beginning of the result set Tag: 196125
  - 9
    - Menus, Problems & Errors Hello, I have trouble using different menus with different forms. I am using VFP 8.0 SP1 1) Main form has top level menu name 'main'. 2) Second form is MDI has menu 'order' called when form is called & release when form is release . Problem#1 with Method 1 When second form is called, Main menu is deactivated when lost focus & activated when got focus. Problem is it's change position of menu & first bar can't be accessed because of icon place from second form. Problem#2 with Method 2 When second form is called, Main menu is released using 'Release Menu " command, when lost focus & called using 'do main.mpr' when got focus. Problem is after few uses, got an error "Not enough Memory to complete this operation'. Problem#3 with Method 3 When second form is called, Main menu is released using 'Release Menu Extended " command, when lost focus & called using 'do main.mpr' when got focus. Problem is after few uses, got an error "Menu Manager internal consistency Error'. I tried all commands related to menu, but no success. Please suggest me best solutions to use different menus with different forms in one program. I wonder why menu system in VFP is so complicated, compare to VB. TIA Jit Tag: Finding the beginning of the result set Tag: 196123
  - 10
    - How to send shapes object in the container to printer? Hi all, I have an apps with an ability to draw lines. The 'drawing pad' is actually a container and the the drawing are collection of shapes that each has specific length, top, left, and width properties. By saving those values on tables, my apps can save and open the drawing. The shape objects has several proprietary properties that are used for specific calculations, the drawing is just used to somehow visualize the entry. Problem begins today when my clients asked me to upgrade the application such that he can print the drawing. Question: Any idea how to send the drawing (which are actually shape objects in the container) to printer? TIA, Willianto Tag: Finding the beginning of the result set Tag: 196122
  - 11
    - Defining the dimensions of an array Hi All, Is it possible in vfp to declare an public array (so that the array is visible anywhere in the application) and then define its dimensions at a later stage (when I know what the size of the array is going to be)? Something like redim in visual basic... Regards. Tag: Finding the beginning of the result set Tag: 196117
  - 12
    - Databases I have developed an application. Now I want to add a "Training" feature that will will the same tables as the "real" application. I have a new database for the training, but all the forms have the database as the original. How can I tell each form that the database has changed from MyData to MyDataTr so that the tables in the training folder can be used with the forms that were created using the original database of MyData? In other words, is there a way to programatically change the database property within each form? Tag: Finding the beginning of the result set Tag: 196107
  - 13
    - FoxPro ODBC Driver? Hi: I am building an application with AccessXP and need to connect to a FoxPro DOS tables (v.25/v.26). The ISAM driver use A97 has been discarded in AccessXP in favor of the Microsoft Visual FoxPro ODBC driver. Can you tell me where the link is on the Microsoft site to download the VFP ODBC driver? Currently on the machine at the client site the driver is v6.01.8629.01 dated 9/21/1999 for vbpodbc.dll. His is a Win98 machine. On my machine, a Win XPPro, the VFP driver is 1.00.02.00 dated 8/29/2002. I am having a problem when I link using the old VFP driver. I have a field called Active that is type Logical (boolean). If I query the table it presents all records. However, if I filter it to all records where Active is True/-1 or False/0 no records are returned. If I create a calculated field where I compare Active to True, those that are true = -1 and those that are false = 0. However, if I attemp to filter on that field again I get 0 records. So something must be wrong with the ODBC driver on the client machine where the ODBC freaks on logicals. Any link to a VFP driver that would be more up-to-date would be appreciated. Tag: Finding the beginning of the result set Tag: 196100
  - 14
    - UDF's in FoxPro indexes I am trying to share foxPro files with Clipper apps using CDX-compatible drivers. The problem is that the index expressions include function names that are incompatible with FoxPro. Some are easy to fix - the Pad() function can be replaced with PadL() for example. However, the Descend() function allows mixed ascend/descend indexes, such as INDEX ON CUSTCODE + DESCEND(INV_DATE) TO... As you can guess, this will produce a sort order of ascending costmer codes, but descending invoice dates. I know how to reproduce the functionality of Descend() in FoxPro by creating a UDF, but I also need to know how to make sure that it is always available every time VFP8 runs - without the user having to explicitly load any procedure files. What is the best practice for this? Also, is it possible to create a DLL or something containing UDF's for index expressions athat can be attached to an ODBC, OLE DB or ADO objects so that other apps using an instance of the FoxPro data engine can also automatically have access to these functions? TIA Carlo Tag: Finding the beginning of the result set Tag: 196096
  - 15
    - UDF's in index expressions I am trying to share foxPro files with Clipper apps using CDX-compatible drivers. The problem is that the index expressions include function names that are incompatible with FoxPro. Some are easy to fix - the Pad() function can be replaced with PadL() for example. However, the Descend() function allows mixed ascend/descend indexes, such as INDEX ON CUSTCODE + DESCEND(INV_DATE) TO... As you can guess, this will produce a sort order of ascending costmer codes, but descending invoice dates. I know how to reproduce the functionality of Descend() in FoxPro by creating a UDF, but I also need to know how to make sure that it is always available every time VFP8 runs - without the user having to explicitly load any procedure files. What is the best practice for this? Also, is it possible to create a DLL or something containing UDF's for index expressions athat can be attached to an ODBC, OLE DB or ADO objects so that other apps using an instance of the FoxPro data engine can also automatically have access to these functions? TIA Carlo Tag: Finding the beginning of the result set Tag: 196095
  - 16
    - Calendar control & VFP9b I'd like the click event of the calendar ocx to update the value property of a textbox which is elsewhere on the same page. However, as soon as any code I put in the click event begins to fire, the calendar reverts to the default date, and I can only get a value for today. Guess I need a calendar control tutorial. Can anyone help? -Lew Tag: Finding the beginning of the result set Tag: 196089
  - 17
    - determine the name of the popup which will be called from the pad I'm creating a menu in the system toolbar, using the following coding, DEFINE PAD PadShortCut OF _MSYSMENU PROMPT "\<Shortcuts" COLOR SCHEME 3 KEY ALT+S, "" ON PAD PadShortCut OF _MSYSMENU ACTIVATE POPUP ShortCuts DEFINE POPUP ShortCuts MARGIN RELATIVE SHADOW COLOR SCHEME 4 Some where else, i want to PUSH the popup ShortCuts, but for this i need to know this name, It could be ShortCuts or ShortCut, or PopShortCut So, basically, given the Title of the PAD, CAN I determine the actual name of the PopUp which will be called?? Regards, Paul Tag: Finding the beginning of the result set Tag: 196086
  - 18
    - disappearing menus Has anyone experienced a situation where the pull-down menus will disappear or somewhat collapse. They get reset once the user logs-out and logs-in again. Thanks, Chris Tag: Finding the beginning of the result set Tag: 196081
  - 19
    - Contract FoxPro Programmer Available for NJ or offsite projects I am a foxpro developer for about 10 years. I was recently laid off and I am looking for any projects related to Visual Foxpro, data processing, website maintenance, and complete rewrites of legacy 2.6 apps to Visual FoxPro. I have a base of solid OOP framework based on the MEI standard that can be used as a good staring point for any new application. If you are in need, please visit my website and give me a call. Thanks Jim www.datacontracting.com Tag: Finding the beginning of the result set Tag: 196077
  - 20
    - tableupdate Hello Is there any way of finding out excacly what table update translates into. ie can i find out the sql command it generates???? any help will be appreciated regards simon haynes Tag: Finding the beginning of the result set Tag: 196063
  - 21
    - TableUpdate() Dear Sir/Madam We are using Visual Foxpro (Version 8 Sp1) and ODBC (Visual Foxpro Driver 6.01.8629.01). We have a severe problem in that when a table has more than 50 fields in it and we are doing a tableupdate() the program crashes with a fatal error: C0000005. I have noticed that this error occurs at the same point (record) as if you have done a copy to array on the table. I.e. at the point the array has reached its 64k limit. (does tableupdate() use an array - if so can this array be cleared?) We have managed to code around the error by saving each reacord after 30 fields have been replaced . Ie using TableUpdate more than once on the table. The problem with this though is that performance is decreased enormously (so much so that the software is unusable). Could you please advise on how this issue could be resolved. Regards Simon Haynes Tag: Finding the beginning of the result set Tag: 196056
  - 22
    - scroll bar for image control hi all, i am working on the project which shows the picture of toys along with its packing list and other details. The problem is some pictures are two big and cant fit into one form. therefore, i tried to change the stretch property to 1 or 2 instead of default clip so that the size of photo can be reduced and can be easily viewed. But some photos especailly the big photos after changing the property are not clear. can we not provide scroll bar or something like that. I mean to say can we drag the photo to see it full. Does image control has some property which can function like this. It will be great help as the project has been already completed and this issue has arrised now. regards gibbs Tag: Finding the beginning of the result set Tag: 196053
  - 23
    - [VFP9B]: What is the meaning of Intellisense-underline things? Hi all, Whenever I write some code and (looks like) the Intellisense is working, the text I typed is underlined. The underline eventually disappear but I cannot figure out what the underline means (it must've meant *something*) Anybody enlighten me please... :-) TIA, Willianto Tag: Finding the beginning of the result set Tag: 196052
  - 24
    - save / restore user settings Hi, Is there an easy way to save and restore "lay-out"-properties that a user has changed upon opening and closing a form. for example : grid.columns.width, form.height/width/top/left. I could make my own one but this probable already exist so if somebody....you know... thanks in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: Finding the beginning of the result set Tag: 196051
  - 25
    - Programmitically add default values Hi. VPM 6.0b, VFP 6 I am trying to add a new record to a customer list that uses s<pre>cgpk to generate the new primary key. I have opened the s<pre>DD2 table, located the record for the table and PK field, then do a: store smsydd2.default to lcRunIt eval(RunIt) The error I get is looking for a DD2DEFAULT table. Can someone advise me on this table? Thanks, Gene Conrad Tag: Finding the beginning of the result set Tag: 196042
- Next
  - 1
    - comments for subclass Hi Experts, How to make our comments in a class appear in subclass ? I need to know parameters that is needed for DoDefault() function in a subclass without opening the class itself. Thanks a lot Tag: Finding the beginning of the result set Tag: 196041
  - 2
    - VFP 6 service pack What is the latest version of VFP 6? I ran Visual Studio Service Pack 6, but it seems not to have changed the VFP version, and no SP is listed in the About box. I see from MS's life cycle schedule that support for VFP 6 has ended. Does that mean service packs will be unavailable? -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - 2 0 0 4 at y a h 00 Tag: Finding the beginning of the result set Tag: 196020
  - 3
    - Memo 2 Command Ok i have a Memo field with some Text Information in it... this information completes a CREATE TABLE command, so I need to do somthing like this but that will work: CREATE TABLE REC03 + table.field Any Idea's? Tag: Finding the beginning of the result set Tag: 196011
  - 4
    - Grid header color and Windows XP theme In VFP 8 I have a grid that I set the headers to change color as the column focus changes. This works OK in classic windows theme but does not change color in XP theme. The grid theme property is set to .T. Anybody come accross this? ----------------------------------------------------------------- Paul Lee ........... Abri Technologies ......... http://abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: Finding the beginning of the result set Tag: 196008
  - 5
    - Query/Program Problem I am getting a Syntax error on the following code... Anyone see whats wrong? CLOSE ALL SET SAFETY OFF xFn = "REC03.XLS" xTn = " REC03" xTs = "" xTs = " (" xTs = xTs + "region c(2), hospcd c(2), filler0 c(2), acct c(11), actype c(1), acctsubtp c(1), contind c(1)," xTs = xTs + "filler1 c(1), rectp c(1), filler2 c(3), createdt c(6), filler3 c(4)" xTs = xTs + ")" CREATE TABLE + (m.xTn) + (m.xTs) SET SAFETY ON Thanks in advance. Tag: Finding the beginning of the result set Tag: 196004
  - 6
    - Creating Macros in User Apps I would like to know if it's possible to access the macro dialog box from within a visual foxpro application. In foxpro I can use SYS(1500,"_MST_MACRO","_MTOOLS") which is fine, but Tools-Macros is not available typically in an app. I've tried to define the menu using the corresponding bar#, that does nothing. I've tried calling sys(1500) from the app, doesn't work. HELP!!!! -- S. Morris System Analyst Tag: Finding the beginning of the result set Tag: 196003
  - 7
    - Release object in a procedure Hi. I have a simple problem Here's my procedure : PROCEDURE DestroyMyObject PARAMETERS TheObject RELEASE TheObject ENDPROC I tried to call it with @ but it has no effect. How can I release my parameters in a procedure ? Is it possible ? Thanks in advance for your help. Tag: Finding the beginning of the result set Tag: 195988
  - 8
    - i made an exe from my program but hi i made an exe from my program but it dont worke and i get this error message could you help me Program Error Cancel Suspend Ignore Help Error loading file - record number 3. form1 <or one of its members>. FontCharSet : Error with Form - FontCharSet : Expression evaluated to an illegal value Tag: Finding the beginning of the result set Tag: 195979
  - 9
    - finding string of one table in another Hi All, I have a table: id1 fld1 ---------------- 1 hand 2 feet 3 leg and second table is: id2 fld2 ----------------- 1 I have two hands 2 six feet under 3 last leg of his tour 4 nothing 5 these two go hand in hand How can I get records of second table THAT CONTAIN text of 'table1.fld1' in 'table2.fld2' by using SQL-SELECT in VPF7. (There should be 4 resultant records). TIA Kamran Tag: Finding the beginning of the result set Tag: 195969
  - 10
    - using double-byte character sets (DBCS) Hey everyone! I'm working on a program that takes keyboard entered words (whose letters each have an ANSI value between 0 and 255) and converts them to charcters and expressions in a given double-byte font. To do this, what I really need is a double-byte equivalent of the CHR() function. But since there isn't such a function, there must be some other way of going about it. Related to all this, when I copy characters to the clipboard using the Windows XP Character Map, they paste fine into all my other windows programs (WordPad, Photoshop) but they always paste in as "???" in VFP6 even though I've selected the display font to show the desired double-byte font. Any help would be appreciated. Scott Tag: Finding the beginning of the result set Tag: 195964
  - 11
    - MSMAPI question I did a form that try to send an email with some attachments. It works great under W98 2nd edition. In Win 2000 in some workstation it said that the class was not registered. I registered using regserv etc.. and it is not working properly I always get the same message, the class was not registered. In other WK under Win 2000 I got an error message in the following line. oform.Message1.send(1) the error was: exception code OLE dispacht 0 de MAPImessages. Unespecified failure has occurred. I do not know what to do. The aim of my program was to built a form that run in almost any environment (Win 98, 2000, XP, etc) using Outlook Express. Any advice will be welcome Thanks in advance Mariano Tag: Finding the beginning of the result set Tag: 195962
  - 12
    - Manuel for ODBC Could you suggest some manual for using ODBC. I am interested in basic concepts and how to work with MySql server... Thanks Tag: Finding the beginning of the result set Tag: 195959
  - 13
    - Playing a WAV File over a Modem We want to play a .wav file over a our PA system in the warehouse when a condition is met. I am told all we need to do is have a modem call an internal for the PA system and then play the .wav file. Does anyone have any experience with doing this. Figured I would ask before investigating this. Thanks Tom Tag: Finding the beginning of the result set Tag: 195955
  - 14
    - Tableupdate always true with cursoradapter and ado Hi, I'm using VFP8 with sp1. I'm connecting to a DBC by using an ADODB connection. Retrieving and updating data works fine. To do that i use a cursoradapter that uses the adodb connection as activeconnection. So far no problems. But when the following situation occurs, tableupdate behaves very strange: User 1 opens a record for edit User 2 opens the same record for edit User 1 updates and closes the record, the data in the record is changed User 2 updates and closes the record, because the data has changed this user should receive an update error but i don't get an error either on the recordset, the connection or with the TABLEUPDATE(1,.F.). I tried several locktypes but i cannot solve the problem. Hope someone can help me out with this. Pat Tag: Finding the beginning of the result set Tag: 195954
  - 15
    - Class Instantiating Problem I have a DLL project with two classes (Let's say ClassA and ClassB). From ClassA I want to call a method in a different class, which is also called ClassB (this is not the same ClassB that is included in the project). Now if I use NewObject('ClassB', Path of ClassB), instead of creating the ClassB from the path I specify, it creates the ClassB that is included in the project. How can I instatiate the ClassB that is stored outside this project? (I guess I did not confuse!) Best Regards, Y. Sivaram Tag: Finding the beginning of the result set Tag: 195951
  - 16
    - Universal Thread Messed Up? Hey folks, Is anybody else having a problem getting the UT message treeview nodes to expand this morning? I can't get any of them to open up in either IE or Mozilla; both browsers report Javascript errors when I try it. Ken Dibble Southern Tier Independence Center Tag: Finding the beginning of the result set Tag: 195950
  - 17
    - How can I insert data into SQL Table from vfp table(dbf file)? Hi, all, I have table named daykj in SQL SERVER, now I want to append data from a vfp native table named _daykj(locate in kjdata), I try the following code, but It seems to be uneffective. cCs="Driver={SQL Server};Server=(local);Database=zwhrp;Uid=sa;Pwd=;" nHandle = SQLSTRINGCONNECT(ccs) nStat=SqlExec(nHandle,"INSERT Into zwhrp!DayKj Select * From kjdata\_DayKj") Anyone can give me idea? Thanks in advance! Chuen Tag: Finding the beginning of the result set Tag: 195947
  - 18
    - How to send a simple HTTP request Hi all, 1- I have a small service running on my server with a little web server. All I want to know is how I can send a simple HTTP GET request to it through my form in VFP9, such as : http://127.0.0.1:8800/?ph=3774&Text=test+123 2-In the same case how can I retreive the HTTP response from the web server ? TIA Tag: Finding the beginning of the result set Tag: 195932
  - 19
    - On Label Key I need to create "Hotkeys" with "+" and "-" in my application. Is there a way to do this? They are not options in the On Key Label command. Thanks, Scott Tag: Finding the beginning of the result set Tag: 195929
  - 20
    - VFP and MySQL Hi, 1. using VFP and MySQL, does it the exe can update data in webserver from remote pc using internet connection ? eg: open table with IP address ? 2. is VFP update speed as good as compare to VB on MySQL ? Regards Hoe Tag: Finding the beginning of the result set Tag: 195926
  - 21
    - CodeMine Framework I'm rebuilding an application in 8.0 using the new version of CodeMine. But, the original developer didn't use, or else save, the original CodeMine environment. Has anyone any experience with this kind of situation? Thanks Steve Tag: Finding the beginning of the result set Tag: 195921
  - 22
    - can u shed some light on this weird class instantiating err Hi friends i created class (class name is ctrHeight.VCX) with container,a label ,commandbutton a textbox in it. when i add this to this a form from toolbar everything works fine. but when i add this control thr code like following thisform.AddObject('cnt','container') thisform.cnt.visible=.t. thisform.cnt.newObject('cntheight','ctrlheight','D:\VSSLocal\vip\ctrHeight.VCX') thisform.cnt.cntheight=.t. i am getting following error "Error instantiating the object "txvalue" (actually it is a textbox)" i am wondering what i am doing wrong here. i just found when i add this control from toolbar and add another control thr code like abv everything working fine??? what i am missing here?? many thanks for ideas -- cheers Tag: Finding the beginning of the result set Tag: 195920
  - 23
    - Shortcut evaluation Hi, I'm having a bit of a headache because of the following: I want to let the user type an expression and check whether it's valid or not eg "x=1 and y=2" Now, the tricky part is that I can't be sure that y (or whatever variable the user makes up) exists at this point. Now, if x equals 0, the "y=2" part is not evaluated, so I won't get an error if Y does not exist and therefor I cannot report this error (so my "expression-validation" routine will not indicate that this expression cannot be used for all values of x). Now the user can make quite some difficult statements (with brackets etc) eg: (x=1 and y=2) or ((b<=3 or c=3) and c>2) or InList(q, 'a', 'b', 'c') So my question is: does anybody have an idea about how to generate a list of all variables used in an expression? R Robert Tag: Finding the beginning of the result set Tag: 195917
  - 24
    - Moving Classes Around I should like to move my classes to another folder. How can this be done without messing-up all classes lower down in hierarchy and object based upon them? Thanks in advance. Shmiel. Tag: Finding the beginning of the result set Tag: 195915
  - 25
    - Nesting of For loops Can the "for" loops be nested in vfp? My program is giving nesting error. for i = 1 to 6 for ..... if.... ---- ---- endif endfor endfor Tag: Finding the beginning of the result set Tag: 195889

Hi All,

I have stored the result of a query in a cursor. My program is such that I need to scroll back and forth in the result set. How can I at any point of time, check whether, I am at the beginning of the result set; so that I don't try to scroll before the beginning of the file?

if cursor_name.bof()
..
..
endif

cursor_name.bof() is giving an error - Object cursor_name not found!

Any suggestions to solve this problem would be greatly appreciated.

Regards

Re: Finding the beginning of the result set by Eric

Eric
Mon Jun 28 03:41:11 CDT 2004

Hello, sm!
You wrote on Mon, 28 Jun 2004 01:30:01 -0700:

A cursor is not an object and it does not have a Bof() method. There is a
BOF() function:

SELECT cursor_name
IF BOF()
...
also
IF EOF() && end of file
...

You can also specify the alias, so that the SELECT is not needed:
IF BOF("cursor_name")

To quickly go to the first record, issue LOCATE
SELECT cursor_name
LOCATE
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Re: Finding the beginning of the result set by christophe

christophe
Mon Jun 28 03:50:59 CDT 2004

Sm,

if bof("cursorname")
...
endif

or another example

do while .not. bof("cursorname")
....
skip -1 in "cursorname"
enddo

christophe
--
\|||/
(o o)
----ooO-(_)-Ooo-------------

¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°
º

"sm" <sm@discussions.microsoft.com> schreef in bericht
news:C6EC2487-193E-4252-BBFD-0E9BBD8EDAE8@microsoft.com...
> Hi All,
>
> I have stored the result of a query in a cursor. My
program is such that I need to scroll back and forth in the
result set. How can I at any point of time, check whether, I
am at the beginning of the result set; so that I don't try
to scroll before the beginning of the file?
>
> if cursor_name.bof()
> ..
> ..
> endif
>
> cursor_name.bof() is giving an error - Object cursor_name
not found!
>
> Any suggestions to solve this problem would be greatly
appreciated.
>
> Regards
>