about using the command "pack"

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
    - Sharing violation - FPD 2.6 The application is developed in FPD 2.6, running in Win 98 with 2 nodes ( peer-to-peer networking ). The config.fp setting is RESOURCE=C:\NetProft\FOXUSER.DBF EDITWORK=C:\NetProft\Temp SORTWORK=C:\NetProft\Temp PROGWORK=C:\NetProft\Temp TMPFILES=C:\NetProft\Temp CATMAN = OFF STATUS = OFF MVCOUNT = 2048 DISPLAY = VGA25 Each system is assigned local drive letter in config.fp ( if not using C: drive ) What could be the reason for sharing violation error ? We get this error not for temp files / cursors, not for dbfs Rakesh Tag: about using the command "pack" Tag: 194306
  - 2
    - Converting seconds to time ( 99999 to 99:99:99 ) Anyone happen to have a routine to convert seconds to hh:mm:ss thanks0 Tag: about using the command "pack" Tag: 194302
  - 3
    - How to pass the string/VFP Cursoft values in SQL Hi... I've a table in SQL which having student informations like ( code, name, age, etc. 1. I want to get the information of the students which codes are mentioned in the variable "stringValue" ( using VFP 8.0 StringValue = "0001,0002,0003,0004,0005,0006,0007,0008,0009,0010 * ------------ * ------------ * ------------ * ------------ * ------------ * ------------ * ------------ 2. How can I pass a VFP Cursor Records in SQL statement using SQLEXEC() Thanks in advanc Rav Tag: about using the command "pack" Tag: 194292
  - 4
    - How to open class from 3.0 in Fox 6.0 When I try to open class from Fox 3.0 it crashs with message: "Fatal error: Exceptin code = C0000005". What that meen? Is there vertical compability? Thanks Tag: about using the command "pack" Tag: 194289
  - 5
    - question no 5 related to photos hi all I have stored the pictures ( JPG, BMP) files in one folder. Now, i want to search whether particular bmp or jpg exist in the directory or not. How can i find it regard gop Tag: about using the command "pack" Tag: 194284
  - 6
    - Write files to CD-R in XP This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C439DC.D4880990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am looking for a way to write files to a CD-R disk without having to = use a third party software to prepare the disk for writing. Win XP = allows one to drag and drop files to the drive via Windows Explorer. = These files are actually in a folder called "CD Burning" buried deep = below the current users account folder. =20 I am able to copy these files to this folder through VFP. I just can't = find any way to "commit" the files to disk through code. Thanks in advance. Steve ------=_NextPart_000_0016_01C439DC.D4880990 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.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I am looking for a way to write files = to a CD-R=20 disk without having to use a third party software to prepare the disk = for=20 writing.  Win XP allows one to drag and drop files to the drive via = Windows=20 Explorer.  These files are actually in a folder called "CD Burning" = buried=20 deep below the current users account folder.  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am able to copy these files to this = folder=20 through VFP.  I just can't find any way to "commit" the files to = disk=20 through code.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Steve</FONT></DIV></BODY></HTML> ------=_NextPart_000_0016_01C439DC.D4880990-- Tag: about using the command "pack" Tag: 194280
  - 7
    - SQL question vfp 3.0 Hi all, I have two tables in vfp 3.0, both tables have a field cId. I want to execute a query against these tables such that it contains: all fields from table1 and a particular field from table2 , for all records of table1 and those records of table2 where the cId is available in table1. For example : table1 table2 recno() cId Field1 recno() cId Field2 1 1 1000 1 1 900 2 2 10000 2 2 9000 3 3 100000 I want to have as result: cId Field1 Field2 1 1000 900 2 10000 9000 3 100000 How could I achieve this? BTW: Do you know good books/links about (complex) SQL queries? Help would be appreciated Zakaria al Azhar Tag: about using the command "pack" Tag: 194275
  - 8
    - Grids, add a combo box with set values Having similar problem to another post but see no resolution in the replies that actually work. Maybe I'm not doing it correctly. I have a grid on a form and want to have a combo (drop down) in column1 that, when clicked, displays three options "Opt1", "Opt2", "Opt3" When I click the column then click the combo button on the form designer and drop it in....VFP it takes me to the control source property and no combo box is added. Spent hours on this and very frustrated!!!! Two questions: 1.) How do I get that darn combo control in Column 1? 2.) Can you give any code samples as to how to reference it and populate with three values? Thanks in advance for ANY input. - Ben Tag: about using the command "pack" Tag: 194264
  - 9
    - CHR() WHAT IS THE CHR() FOR A COMMA THANKS MARY Tag: about using the command "pack" Tag: 194261
  - 10
    - How to determine whether a table is in or not in a database? Is there a simple method to determine whether a table is in or not in a database? thks in advance! Chuen Tag: about using the command "pack" Tag: 194253
  - 11
    - ActiveX control events not fired ! Hi all, I'm developing a new ActiveX Control in Delphi 5 to use in Foxpro. Using it in Delphi and .Net it works fine and all events are fired. But using it in Foxpro doesn't. I really don't know how to solve this problem. Please help ! -- Andre Azevedo Tag: about using the command "pack" Tag: 194250
  - 12
    - Generics my arse We, as privileged fox developers, have never needed "generics" in more = than 10 years of fun. Why is it so important right now for the so called "strongly typed = languages" (see Java and C#) ? things =3D NewObject("collection") things.add("one") things.add("two") what is so difficult or dangerous or crazy about that? Good luck for you strong typers out there. Have as much fun as we have had in the last decade=20 ;-) Tag: about using the command "pack" Tag: 194249
  - 13
    - Procedure writing text to screen adds on ".T." I wrote a little function that tells me how many days it's been since a start date that you choose with a calendar function: PROCEDURE since PRIVATE ldDate, lcDays ldDate=calendar() && I pick the start date lcDays=ALLTRIM(STR(DATE()-ldDate)) =ALERT(" It has been "+lcDays+" days.") ?" It has been "+lcDays+" days." RETURN My alert() function is like a messagebox(), so it shows me the answer in a window. It then writes the same answer to the Foxpro screen. However it gives an answer on the screen like this: It has been 64 days..T. Why is it adding on the .T. and how can I stop that? Thanks. - - - - Well, I just discovered that if I rewrite the procedure to RETURN " It has been "+lcDays+" days." and eliminate the ? clause, it resolves the problem. I don't remember seeing this before in Foxpro. Tag: about using the command "pack" Tag: 194243
  - 14
    - Procedure writing text to screen adds on ".T." I wrote a little function that tells me how many days it's been since a start date that you choose with a calendar function: PROCEDURE since PRIVATE ldDate, lcDays ldDate=calendar() && I pick the start date lcDays=ALLTRIM(STR(DATE()-ldDate)) =ALERT(" It has been "+lcDays+" days.") ?" It has been "+lcDays+" days." RETURN My alert() function is like a messagebox(), so it shows me the answer in a window. It then writes the same answer to the Foxpro screen. However it gives an answer on the screen like this: It has been 64 days..T. Why is it adding on the .T. and how can I stop that? Thanks. Tag: about using the command "pack" Tag: 194240
  - 15
    - XP and NT4 speed issues I understand there is an issue with XP workstations on an NT4 server which slows down VFP apps. I am told it is to do with NT4 trying to do its own locking in addition to or competing with VFP locking. I am also told there is a way to turn this off in NT4. Is this correct? Does anyone know how to disable this within NT4 so that my VFP apps on Windows XP will speed up somewhat? Cheers David Younger Tag: about using the command "pack" Tag: 194227
  - 16
    - RDS ADO/RDS Internet Server Error: Object/module not found I'm trying to use RDS to access a FoxPro table remotely, I can't get passed this error. This is a new feature I'm trying to implement, so I'm not sure what to look for to rectify this. Can anyone lead me in the right direction Tag: about using the command "pack" Tag: 194217
  - 17
    - Additional Code Pages in VFP8 Are there any additional code pages supported in VFP8 (or VFP9 BETA) that are not supported in VFP7? Tag: about using the command "pack" Tag: 194214
  - 18
    - Foxpro7 and Foxpro8 on same computer? Is it possible to install Foxpro7 and Foxpro8 on the same PC? Of course I would like to still have the option of which version I would use Thanks Tag: about using the command "pack" Tag: 194203
  - 19
    - vfp 5.0 setup wizard The setup wizard creates runtime distribution disks, but while running setup on Win2000, the setup.exe gives Setup error no 799, Object 40,'Your setup files may be damaged, Try restarting the setup program'. But the error is always repeated. Please help. Tag: about using the command "pack" Tag: 194197
  - 20
    - Help With DECLARE DLL I need to utilize some functions in a 3rd party dll. I'm using the DECLARE statement, but I keep getting the "Cannot find entry point FuncName in the DLL". I used dumpbin /exports on the DLL. The function names look like this: _Function1@8 _Function2@8 I've also tried: DECLARE integer FunctionName IN that.dll ALIAS "_Function1@8" But this returns the same error. Can someone help me with these decorated function names. Thanks! Tag: about using the command "pack" Tag: 194196
  - 21
    - SQL Query Dilemma I have a table (fictional table for simplicity purposes) Table: 1. CustNo 2. InvNo 3. InvDate 4. InvTotal Lets say the table has 10,000 records with 250 different customers over a period of 4 year (2000-2004). There can obviously be many records for the same customer . I want to run a query to pull the most recent invoice for all my customers as of 12/31/2003. Assuming they have an invoice on or prior to 12/31/2003. How do I do this? Thanks in advance Tim Cairns Tag: about using the command "pack" Tag: 194195
  - 22
    - errors when upgrading from VFP 6.0 to VFP 8.0 Has anyone had experience resolving the following two errors when upgrading your applications to VFP 8.0? 1) Error Number 2034: Date/datetime evaluated to an invalid value. This error happens at seemingly random times - and when trying to repeat the error using the same user/application/steps/data/PC, it is often not repeatable. We do not change the SET DATE setting from the default value (I have seen other postings where that was suggested as a potential cause). Is there anything that might correct this problem (SET STRICTDATE, etc.) ? 2) Error Number 2066: Index file "DBF FILE PATH/NAME" is corrupted. Please rebuild it. As with 1), this error seems to occur at random times and generally is not repeatable. We have a VFP 6.0 application and database that we are planning to upgrade to VFP 8.0 We use two builds of the application that are running in parallel (one in 6.0 and one in 8.0). The tables are reindexed nightly in VFP 6.0 In the VFP 8.0 version only, we have SET ENGINEBEHAVIOR 70 and SET TABLEVALIDATE TO 0 - the two builds are otherwise identical (the same source code). Does anyone have any clues how to correct the behavior described above? Any insight and suggestions would be much appreciated! Thanks in advance. -- Trevor Feldman Tag: about using the command "pack" Tag: 194190
  - 23
    - Insert Before / After Does somebody now the whole syntax of this "old" command ? thanks in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: about using the command "pack" Tag: 194179
  - 24
    - Keypress Event Hi Expert Please suggest me for this stupid problem, I have a form with 4 Text boxs ( Text1, Text2, Text3 & Text4). on Text1 i put Keypress Event as following If nKeyCode = 1 Thisform.Text3.Setfocus( EndI First focus on Text1, then I enter some text on Text1 textbox after that I press ENTER key, now focus move t Text4 not on Text3 as I want in code. Does anyone know this.. Thanks & Best Regard Hidaya Tag: about using the command "pack" Tag: 194176
  - 25
    - Memo fields in a Grid What are the settings for showing data in a memo field on a grid. All that shows is the word Memo Thanks a lot. Tag: about using the command "pack" Tag: 194172
- Next
  - 1
    - Controls being refreshed twice! I have been battling for a long time now to work out why controls on my form get refreshed 2, 3 even 4 times when the form is refreshed. All this refreshing is unnecessarily slowing down my system and the form in question is a very complex one with hundreds of controls. My form is based on a class. In the Refresh method of the form, I have some form specific code and then I include a DODEFAUT() to run the refresh method of the base class. I have discovered that doing this causes all controls to be refreshed twice. In my case it is even worse as I have multiple levels of class. I would have thought that calling the dodefault of the refresh method would just run the refresh code, not rerefresh the form. Is there a way to stop this without having to rewrite all my application over? Cheers David Tag: about using the command "pack" Tag: 194165
  - 2
    - VFP 7 SP1 very slow on an NT4 network We have a VFP7 SP1 application running on a Lan. All users of XP or Windows 2003 Server run very slowly, whereas Win 98 and Win2K workstations are much better. By slowly, I mean it hangs for long periods of time becoming almost unusable. Our server is NT4. Any ideas as to what to do about this? I have done all the usual internal tweaks I can think of, sys2030, buffering etc. Cheers David Younger Tag: about using the command "pack" Tag: 194163
  - 3
    - VFP 3.0, WinXP, Insuficient Memory I have a payroll system developed in VFP 3.0 and now it starts to run into Win xp, when you doble click in the exe file i got a message error "Insuficient Memory Does anybody know how to solve this problem?? and why it is happening?? Any suggestion will be welcome Thanks al Marian Tag: about using the command "pack" Tag: 194157
  - 4
    - Changing color of titlebar Hi, Is there a way to programmatically change the color of a titlebar? Tag: about using the command "pack" Tag: 194154
  - 5
    - CursorAdapter.CursorSchema limited to 255 I am trying to get some experience with using the new CursorAdapter in VFP 8.0. I set DataType to NATIVE and try to create a cursor with all fields from the table. BuyCo.* It fills in the schema with a length over 255 and it will not let me go on. It will let me leave it blank. It won't accept .NULL. as a value. This is on a form with many textboxes that are filled by the fields of the table. Can I use the builder to create the CursorAdapter? Any ideas what I am doing wrong? Thank you, Michael Wheat Tag: about using the command "pack" Tag: 194148
  - 6
    - VFP5 under XP pro Running XP pro: When I run a VFP5 program in interpetive mode, it works fine. But when I compile into .exe, it does not respond Does XP require a later version of VFP? Tag: about using the command "pack" Tag: 194146
  - 7
    - read only ODBC connection How do I connect to fox pro v 6 via ODBC driver with a read only connection and not a read/write? Tag: about using the command "pack" Tag: 194141
  - 8
    - odbc for windows xp I need to use a VFP ODBC but my user is using windows XP home When I try to create the new ODBC and choose the Visual Foxpro ODBC driver, it says I need to upgrade the visual foxpro odbc driver. When I go to the microsoft visual foxpro web site, and choose to download the odbc driver, there's a warning saying it's for win 98, win Me, and NOT to use with windows 2000. It doesn't even mention windows xp I also downloades the MDAC 2.8, but it says it contains the SQL odbc driver and doesn't have the visual foxpro driver Where is that driver? Where can I get it? Please, help me!!! Tag: about using the command "pack" Tag: 194131
  - 9
    - smart cursor I have defined this class: DEFINE CLASS SmartCursor AS Custom CursorAlias = "" PROCEDURE Init LPARAMETERS tcCursorAlias this.CursorAlias = tcCursorAlias ENDPROC PROCEDURE Destroy IF (!EMPTY(this.CursorAlias)) THEN IF USED(THIS.CursorAlias) USE IN (THIS.CursorAlias) ENDIF ENDIF DODEFAULT() ENDPROC ENDDEFINE In the code: loCursor = NEWOBJECT("SmartCursor","mylib.prg", NULL, SYS(2015)) *** fill the cursor from database GetData(loCursor.cursoralias) *** perform some task LOCAL lcAliasTmp lcAliasTmp = loCursor.cursoralias SELECT &lcAliasTmp..filed1 . My question is: Is it possible somehow to write: SELECT &loCursor..filed1 . or even better SELECT loCursor.filed1 . Maybe, using some feature like PROCEDURE THIS_ACCESS. Thanks in advance Sanjin Tag: about using the command "pack" Tag: 194125
  - 10
    - Outlook and VFP Hi group, following scenario: I use Outlook as a COM Server. The user copies for example 3 mails in outlook in the clipboard, and wants to make an action on them in VFP. So, I have to know in VFP, which mails are in the clipboard. I tried it with VFP tools, no success, I tried the API, (dragqueryfile, OpenClipboard, ....), no success. Does anybody can help me? Bastien Tag: about using the command "pack" Tag: 194122
  - 11
    - VFP7 Frequent Fatal error C0000005 on PACK One of our clients is having a really strange problem intermittantly - 4 times in the last 2 weeks. During a process which they run every day, they sometimes get a fatal error C0000005 on the PACK command of the following code local llExclFla llExclFlag=.T ON ERROR DO EXCL_ERR WITH llExclFla use procblok exc if llExclFla pac us endi =o_error("default",0) &&turns the default error handler back o Function Excl_er parameters p_exc p_excl=.f return p_exc After the fatal error, the file has disappeared completely and we have to resend them a blank one. We have renamed the file and resent it so that it uses a different area of disk. But it still keeps happening. The file concerned is updated by processes in our application which add a record then deletes that record once the process is finished basically to stp other users running the same process at the same time. So the file only contains a few deleted records each time it is packed Any ideas about what could be causing this problem? We're running out of ideas Thank Bernie Tag: about using the command "pack" Tag: 194120
  - 12
    - [Error]Import data from vfp to sql server ! i have one database which got 30 tables, I want to import these data into sql server, I found that during "import ", there are Error occured, why ? Moreover, for one specific tables, the sql server seems 'hangs", i had wait over 3 hrs. the process seems held or dead , I need to use task manager to end up it . Does anything wrong in my tables ?? Thanks From Agnes Tag: about using the command "pack" Tag: 194118
  - 13
    - crystal report problem I have a foxpro program that called Crystal Report: thisform.olecontrol2.reportfilename = xReportName thisform.olecontrol2.datafiles(0) = fnd thisform.olecontrol2.connect = 'DSN=TEMP' thisform.olecontrol2.destination = 0 thisform.olecontrol2.printreport The Crystal report just forked off the thread and the Foxpro program cotninued to execute. How could make Foxpro to wait for the Crystal Report thread? Something like calling DOS and wait for execution... -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 5:32pm up 11 days 18:55 load average: 0.97 1.00 1.00 Tag: about using the command "pack" Tag: 194117
  - 14
    - May 2004 Letter from the Editor New info on VFP9 and additional code samples for VFP8 http://msdn.microsoft.com/vfoxpro/letters/ -- Eric den Doop www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8 Tag: about using the command "pack" Tag: 194113
  - 15
    - how to change picture from every column of grid hi all, this is my fourth question related to my application having half form with grid and half form shows image list control as the user scrolls through the grid , the imagelist control shows the changing pictures of products. I put the code in the afterrowcolchange event of the grid for changing the pictures. I have three coloumn in my grid , once i move downwards on the first column the picture changes, but if i place the cursor on second column and moves downwards, than there is no effect on the picture and it remains same of the previous one. How can i change the picture from all the columns of the grid once again , this problem i am facing since last five days, i hope eric and others will help me regards gibb Tag: about using the command "pack" Tag: 194108
  - 16
    - Pocket xBase? Anyone have any experience with http://www.pylin.com/docs/doc_xbase.asp After years of looking for other PocketPC/Fox options, this looks pretty good on first trials. My initial testing was with a 1200 record Fox 2.6 file with memo fields and a complex index and it even uses the Fox cdx. Any feedback appreciated. Beverly Howard [MS MVP-Mobile Devices] Tag: about using the command "pack" Tag: 194101
  - 17
    - Conversion from FoxPro Table application to Foxpro Database I have a Foxpro application in which my data is stored in FoxPro tables. What needs to be done to covert these tables to a FoxPro database and what needs to be done change my code to access this new database? Are there any conversion tools available? Thanks Tag: about using the command "pack" Tag: 194097
  - 18
    - Writing to FoxPro tables from tempfiles I have had problems saving data back to Foxpro tables. Data intermitantly comes up missing. I am writing in VF8.0. Anyone experiance this problem..? Basically, my app deletes old data in the foxpro tables and then inserts into these tables from a tempfile. Tag: about using the command "pack" Tag: 194096
  - 19
    - Does foxwish@microsoft.com still work ? It's time for my annual request to have a MICROSOFT product (that being the future VFP9) have the ability to import a MICROSOFT file format properly (that being Excel 2000 and beyond).... -- Paul Tag: about using the command "pack" Tag: 194093
  - 20
    - Need Visual FoxPro ODBC driver Join Syntax and Registry Key I'm having trouble doing a LEFT OUTER JOIN in Crystal Reports (input files are all Microsoft Visual FoxPro type) - and the directions say I need the "Join Syntax" (such as PlusEqual for Oracle, or OJSyntax for SQL Server 2000) - and the "Registry Key" (such as OracleJoinBuilder or SQLServerJoinBuilder) - for the database type. Does anybody have the Join Syntax for Left Outer Joins for FoxPro files? And the Registry Key name? Here is a link to the directions for Left Join issues in Crystal Reports http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_left_outer_join.pdf.as I really appreciate your help!!! Tag: about using the command "pack" Tag: 194087
  - 21
    - Chinese Characters in Tooltips property. Do anybody knows how to display Chines Character using the Tooltips property on a Form Yours Sincerely Pghill4 Tag: about using the command "pack" Tag: 194086
  - 22
    - - How do I resolve this strange textbox behavior? When the last character is filled into any of the textboxes with a specific InputMask ('XXX', '####', or '##/##/####'), the cursor instead of jumping over to the next control (according to TabIndex) remains in the same textbox and steps back a character. Can anyone explain why? The textbox is not subclassed in anyway, nor it is linked to a ContolSource. The problem is persistent only outside of development environment. Tag: about using the command "pack" Tag: 194077
  - 23
    - Runtime Hi! Where I can find the runtime in VFP 7.0? in VFP 6.0, the files were; vfpodbc.dll vfp6enu.dll vfp6r.dll vfp6renu.dll Im sorry for my ignorance:-( I am still a neophyte. Thanks a lot. /patrick Tag: about using the command "pack" Tag: 194056
  - 24
    - prevent typing in combobox A combox allows user to input text or select a value from the establiashed list of values. How could I prevent a user from typing his own things into the combobox while allowing him to select from the list of values? Right now, I have to validate combobox.value against the list of values in the validation method? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 5:48pm up 10 days 19:11 load average: 1.00 1.01 1.00 Tag: about using the command "pack" Tag: 194054
  - 25
    - Not Embeddd Microsoft Photo Editor Hello All, So I created a program which included imaging program for a client. Without checking into things too deeply, I created my monster around the OLE of Microsoft Photo Editor. It was on my machine, it was on their machine, it seemed likely to be loaded on most machines. While my application works fine on most of their systems, AND I found out how to install it on the latest versions of office (since it is no longer automatically installed.) Im wondering what to do with machines in the warehouse and branch offices which do not have MS Office installed. Is there a better image OLE to use in order to display GENERAL IMAGES on a form? Is there a way to license just the MS Photo Editor with my application? Thanks, Jim Tag: about using the command "pack" Tag: 194041

Hi
I have aproblem of using the command "pack". I usually wrote this word to permanently erase a record as I hit "delete button". But it always jumps out an error message "You have to open it in exclusive mode". Is there any extra sommands I miss or something I get worng. My code of "delete" button is as follows
sele table
set multilocks o
CURSORSETPROP("BUFFERING",3,'table1'
del
pac
begin tra
if tableupdate(.f.)=.f
rollbac
tablerevert(.f.
els
end tra
ski
end
How to fix it? please help
thanks
patrick

Top

Re: about using the command "pack" by Eric

Eric
Sun May 16 07:16:05 CDT 2004

Hello, patrick!

You can only PACK tables that are opened in exclusive mode:
USE yourtable EXCLUSIVE
PACK

It's usually bad practice to PACK a table each time a record is deleted. You
can't use this technique in mutli-user applications and it can slow down the
performance of your app. Take a look at the SET DELETED ON | OFF command in
VFP help. This setting allows you to 'hide' deleted records. Run PACK code
only in your DB maintenance procedures
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Top