fox table question

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - Control Excel Application loExcel.Quit() loExcel = null Tag: fox table question
  - 2
    - SQL Select using variables Thank you very much for your help! Tag: fox table question
  - 3
    - CREATE TABLE, but where is it saved on the drive?! Naomi, the folder VFP does exist on my C. dni, the file is not saved anywhere, I’m actually getting an error: “Invalid path or file name.” Tag: fox table question
  - 4
    - MasFoxPro (MoreFoxPro) campaign This is a message to inform you of the MasFoxPro (MoreFoxPro) campaign and encourage you to support it. We suppose your already know Microsoft announced that there would be no Visual Foxpro version 10. You can find it at: http://blogs.msdn.com/yag/archive/2007/03/13/message-to-the-vfp-community.aspx and: http://msdn2.microsoft.com/en-us/vfoxpro/bb308952.aspx Both announcements lack a convincing explanation or logical reason why Microsoft decided not to release a new version of Visual FoxPro. This announcement has been a major blow to the FoxPro community. This is especially true for the medium and small application developers (the vast majority of developers in Visual FoxPro), that have many years of Visual FoxPro code. It is not practical or cost effective to attempt to move these applications to Microsoft's recommended development environment (.NET). The community must rethink its future development platform. This campaign was created as an idea that originated in the Spanish FoxPro Microsoft newsgroups. Mas stands for more in Spanish. PortalFox and the MVPs that manage PortalFox, as a part of the community, decided to offer a way (hosting and support) to let the community to express itself and promote this campaign. March, 22th of 2007, a Wiki called MasFoxPro was created at: http://www.masfoxpro.com Remember that this campaign does not only focus on the collecting signatures. There are more actions (even more important than the signatures), More information regarding this campaign can be found at: http://www.masfoxpro.com/Masfoxpro We encourage you, your user group or web page support this campaign. Long term persistence could possibly give us an opportunity for some kind of success. Anyhow this your opportunity to FoxPro and the FoxPro Community. It is a worldwide campaign, not limited to any specific user groups. If your users group or web page supports this campaign, you can add your URL and data here: http://www.masfoxpro.com/Sponsors If you want to link us (please do it), The official link is:: http://www.masfoxpro.com the logo located at: http://www.masfoxpro.com/images/logo.gif Also we ask you to pass this email to other users, user groups, developers, press, blogs, etc. Is quite relevant that this campaign have world wide participation. Thanks for your attention. PD: PortalFox is the main Spanish talking developers portal in Visual FoxPro. With over than 28,000 registered users worldwide, is affectionately known as "El Portal del Pueblo" (People's Portal). More info regarding PortalFox is available at: http://www.masfoxpro.com/PortalFox http://www.portalfox.com For more info regarding the MasFoxPro campaign go to his website ( http://www.masfoxpro.com ) or contact with managers@masfoxpro.com Tag: fox table question
  - 5
    - Server Name? Thanks DNI, Please give me some time to work with that Win API code and I'll try to let you know results, ASAP. Tag: fox table question
  - 6
    - REPLACE command help wanted I ment categories.cdx The index file assocated with the table you are useing. If you are geting an error on the "set order to" to me that indicates a problem the index. So if you cant open the index of the index is bad , you can't seek properly. ps i know next to nothing about .net . >> It is annoying to type "set order to" every time i find it more annoying to have to worry about the order.. simple things like "copy to" or "select into" become big problems. But to each there own. Tag: fox table question
  - 7
    - Top level windows are not activated VisualFox 9 I made an plication and I set all the windows with top level show and _sreeen.visible=.f. but when I start the application the main window is in the front an it is not activ. I have to click on it to activate it or if there is a nother application runing like explorer or other my window is minimizetr or in the bootm of the windows and it is not activ. If I activate it and I call a nother window with do form .... a form that is set with top level show the same think is happening. What can I do Tag: fox table question
  - 8
    - CONFIG in top-level application Actually, SYS(2019) has been around forever. I think it goes back to whenever Config.FP files were added to the product. Tamar Tag: fox table question
  - 9
    - VFP9 application in same network with email server & VOIPs Reality manifests itself in many ways. I'm reminded of a client who complained our software was slow. Nobody else had that complaint and this client refused to believe it could possibly be their network. No problem there! On investigation, we discovered that the NIC in their server was throttled at 10 Mbit. Once we removed the throttle and let it operate at 100 Mbit the application started behaving properly and quickly. Their comment to us was "Wow, everything else is faster too, so what's wrong with your software " Your case is black and white. Before VOIP, it was fast. After, it's slow. It isn't rocket science to see cause and effect. You can, of course, use packet sniffers to determine what's using up the bandwidth but those are tools of professional hardware jockeys. Those guys are expensive. A less expensive test would be turning off VOIP for a day. Tag: fox table question
  - 10
    - Visual Foxpro Grid is hiding something from me :( ok ! I have a form with a pageframe and two pages. i have a grid on page 1 for sales_items. i have two MySql tables 'sales' and 'sales_items'. i have set the allowaddnew property of the grid to .T. . try to add a new record to the grid and save it (it works fine) now on the grid press the down arrow more than 4 times so that it will look like ur adding more than 4 new records, and then run the update on both tables and walah ! the grid loses its data, but if you browse the table using a button or something, you will see that the data is actually still there but the grid wont show it. here is a sample of how i requery my child table. Please read the notes with a NOTE marker ThisForm.pageframe1.page1.Grid1.RecordSource="" NOTE the problem starts here, after the grid1 recordsource is set to "" after this, grid hides the content NOTE the grid is set to "" before requerying the sales_items table to retain the actuall layout of the grid lcSQLStmt="Select * from sales_items where TRIM(s_ctrl)='"+ALLTRIM(sales.s_ctrl)+"'" =sqlexec(lnHandle,lcSQLStmt,"sales_items") IF !make_updatable("sales_items","si_uid","sales_items","",.F.) =MESSAGEBOX("sales_items",0,"c") ENDIF with ThisForm.pageframe1.page1.Grid1 .RecordSource="sales_items" NOTE here we set the recordsource back, u can even place a messagebox here to see if the grid recordsource NOTE has been updated (it is updated) but the grid doesnt show anything .columns(1).controlsource="sales_items.is_code" .columns(2).controlsource="sales_items.is_Ctrl" .columns(2).combo1.requery() .columns(3).controlsource="sales_items.emp_Ctrl" .columns(3).mycombobox1.requery() .columns(4).controlsource="sales_items.si_qty" .columns(5).controlsource="sales_items.si_price" .columns(6).controlsource="sales_items.si_amount" .columns(7).controlsource="sales_items.si_discount" .Refresh ENDWITH what is weird is that from my button "ADD" "EDIT "SAVE" "CANCEL" ,after the grid shows no sign of life and i press SAVE (still nothing) , and then press ADD and CANCEL the grid shows its contents back , but i cant keep on simulating the ADD CANCEL buttons everytime i execute the SAVE button , this could decrease the performance of my applications especially if im using Large Tables. NEED HELP PLSSS any1 T_T Tag: fox table question
  - 11
    - How to get the dbf table's Field Name and Field Type and Field Size Ooops you edited your question in between! For memo field size is always 4 how come you have 50 there It's not dynamic, it's a hardcoded value. You may simply do: select code,name,dept,salary, left(remark,50) as remark from myTable into cursor newTable readwrite Or: Code Snippet dimension aNewStruct(afield(laFieldInfo),4) for ix=1 to aNewSruct(laFieldInfo,1) for jx = 1 to 4 aNewStruct[m.ix,m.jx] = laFieldInfo[m.ix,m.jx] endfor if aNewStruct[m.ix,2] = 'M' aNewStruct[m.ix,2] = 'C' aNewStruct[m.ix,3] = 50 endif endfor create table myNewTable from array aNewStruct PS: Be carefull with tables that have long field names. Tag: fox table question
  - 12
    - VFP9 application in same network with email server & VOIPs Reality manifests itself in many ways. I'm reminded of a client who complained our software was slow. Nobody else had that complaint and this client refused to believe it could possibly be their network. No problem there! On investigation, we discovered that the NIC in their server was throttled at 10 Mbit. Once we removed the throttle and let it operate at 100 Mbit the application started behaving properly and quickly. Their comment to us was "Wow, everything else is faster too, so what's wrong with your software " Your case is black and white. Before VOIP, it was fast. After, it's slow. It isn't rocket science to see cause and effect. You can, of course, use packet sniffers to determine what's using up the bandwidth but those are tools of professional hardware jockeys. Those guys are expensive. A less expensive test would be turning off VOIP for a day. Tag: fox table question
  - 13
    - Accessing Web Service using Visual FoxPro 8 I much experience in FoxPro (not any really), but I have been given a task to to try to access a Web Service. I can define the service to access with the Task Pane easily enough but what I am having trouble doing is retrieving the data into a meaningful type when calling the method. For e.g. LOCAL ResultSet LOCAL loGMWService AS "XML Web Service" * LOCAL loGMWService AS "MSSOAP.SoapClient30" * Do not remove or alter following line. It is used to support IntelliSense for your XML Web service. *__VFPWSDef__: loGMWService = http://192.168.101.197/gmwservice/GMWService.asmx WSDL , GMWService , GMWServiceSoap LOCAL loException, lcErrorMsg, loWSHandler WITH THISFORM TRY loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC\")+"_ws3client.vcx") loGMWService = loWSHandler.SetupClient("http://192.168.101.197/gmwservice/GMWService.asmx WSDL", "GMWService", "GMWServiceSoap") * Call your XML Web service here. ex: leResult = loGMWService.SomeMethod() ResultSet = loGMWService.GetNextRecords(.TxtGroupID.Value, .TxtOfficeID.Value, 10) CATCH TO loException lcErrorMsg="Error: "+TRANSFORM(loException.Errorno)+" - "+loException.Message DO CASE CASE VARTYPE(loGMWService)#"O" * Handle SOAP error connecting to web service CASE !EMPTY(loGMWService.FaultCode) * Handle SOAP error calling method lcErrorMsg=lcErrorMsg+CHR(13)+loGMWService.Detail OTHERWISE * Handle other error ENDCASE * Use for debugging purposes MESSAGEBOX(lcErrorMsg) FINALLY ENDTRY ENDWITH The data returned into ResultSet of type 'ArrayofCommand', what options are available to how should I define ResultSet and be able to iterate through the resulting array which may not be of a set size Thanks for the help Tag: fox table question
  - 14
    - Get column name in SQL query I didn't actually meant to shout, but somehow my initial response was in so unreadable font, that I have to change it. I repeat, the only correct way here would be to write it as select &lcFiled as (m.lcNewField) ... My simple test should be enough to confirm it. Tag: fox table question
  - 15
    - Delete any file/subfolder from a directory Hi, I would need to delete any file and folder below a specific directory. I can delete files with the "ERASE *.txt" command but I don't know how to delete the subfolders which themselves contain files. Also, I don't know in advance the name of the subfolders as they are created by an application. So the names can be anything! I there any way to delete any structure (folders & files) below a specific directory Thanks in advance. Tag: fox table question
  - 16
    - RLOCK on a DBF file on a Windows Vista Shaded Folder You may log on as administrator to see what is happening.... You may try to put set multilocks off...Can you show the piece of code whwre are you using rlock May be the problem will be solved with SP2 for Vfp who has Vista support. Tag: fox table question
- Next
  - 1
    - sam error 1529 I get this error when running sam and it wont go away please help me. here is what i get from beginning to end error (1526) error creating cursoradapter: connectivity error:[microsoft][odbc sql server driver] [dbnetlib] connection write(send)()). veiw tmppat not created. application sam version 3.0.765 program:rscursoradapter.doquery line 700 time 09/26/2007/ 10.09 am sql odbc connection is invalid how can I fix this Tag: fox table question
  - 2
    - Speed with CALCULATE To Naomi Nosonovsky, Tamar E. Granor, and CetinBasoz: To say that I greatly appreciate your time, insights, and expertise is a gross understatement. I will be out of town for a couple of days but will work hard next week to digest and implement what you've graciously shared. Thank you. Ed W Tag: fox table question
  - 3
    - Validations Code Snippet lcCustName = ALLTRIM(thisform.text2.value) IF Empty(lcCustName) then MESSAGEBOX("Please enter customer name") RETURN 0 ENDIF IF LEN(lcCustName) > 15 then MESSAGEBOX("Please enter correct name") thisform.text2.SetFocus RETURN 0 ENDIF The only change I made is EMPTY instead of IsBlank and return 0. Also note, that you can not SetFocus in Valid event. Tag: fox table question
  - 4
    - Need help with report expression You are right. Thanks. Tag: fox table question
  - 5
    - how to enclose quotation marks in a string... two ways to represent a string MyString = "hello world" MyString = 'hello world' if you want to put quations in a string then all you have to do is alternate them. for example MyMacro = "select * from ff_tables where ItemName = 'daizy flowers' into cursor c1" simply as that. Tag: fox table question
  - 6
    - VFP9 - Windows Vista - proble with writing in ProgramData folder You are right, by default ProgramData has no write access. I changed setup program to set required NTFS rights and now it's OK. Thank you. Tag: fox table question
  - 7
    - Employee ID No. If two employee enter with the same date and it will base also in Surname. Tag: fox table question
  - 8
    - How to change a kind of propertyiy in all forms and formsets in a project? Hello everyone: Could you give me an example of how to change a kind of propertyiy in all forms and formsets in a project, thank you! Tag: fox table question
  - 9
    - Little Doubts with Reports - Tables Area........... Hi CetinBasoz, Markish, Tamar Yah...After giving the ReportPreview file location...the problem is solved and working very nicely. Really honour will be in honourable place.....Atleast take my Thanks.... Thanks for all reply With Regards....PARAMU Tag: fox table question
  - 10
    - need foxpro help Hi Cindy, I need help related to Foxpro running in Windows Xp. As per the link, I download all the patches but still I am getting an error when I run the patch Patch26. The error is "Incorrect Foxpro 2.6a file size : <Path/file passed to patch26" Please help as I need this desparately. Thanks Vishal Tag: fox table question
  - 11
    - iNSTALLATION dISK In Visual Foxpro Version 7.0 how to create an installation disk Please help me and give me the step by step procedure. Thank you Tag: fox table question
  - 12
    - DELETE / PACK You may try to do it through EXECSCRIPT (this techinique was discussed here before in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1772231&SiteID=1 ). Tag: fox table question
  - 13
    - REPOST: NOPAGEEJECT not working in VFP9 No, your problem is not with a printer driver. What's more interesting is that with the old versions of foxpro you had the options of page eject either before, or after printing. You could also unselect all. And the old versions of foxpro had by default the 'eject page BEFORE report' selected. Nothing like that in VFP. So, once again, not every rendering problem with VFP is a driver issue :-) Tag: fox table question
  - 14
    - Not Enough Memory o Complete the Operation. OK, I did a small surgery on my SP. I changed the Table I was going to PACK to the name of my SMALLEST Table with perhaps 40 rows. There were NO records marked for deletion in it. Also I removed SELECT statement. PROCEDURE testing SET PATH TO "C:\VFP_Projects\Data\ComeAndGetDatBase\" OPEN DATABASE comeAndGet EXCLUSIVE USE crossRefFirstLevel IN 0 PACK USE CLOSE DATABASES ALL ENDPROC The result: The exception related to inability to read/write protected memory disappeared but the "out of memory" exception persists. This appears to be the FINAL stumbling block to the resolution of the whole ordeal. Any insight Still I want to find the place where Temp files (tables) are stored and redirect the stream from it. Perhaps it will help. Thanks. Tag: fox table question
  - 15
    - Color in command buttons Hi, I want to know how to change background color to command buttons and calendar controls. I don't find any property like backcolor in these kind of objects. Thanks, Tag: fox table question
  - 16
    - Web page scrapping form Visual FoxPro I am not sure if this is even possible so i will just say what i am hoping to accomplish and let you all tell me how crazy it is. i want to have a foxpro application on my computer that opens a set of webpages i want to knoe if it is possable to look for a set of numbers on the page once it is opened. the numbers will probly never be the same. is this possible in FoxPro 8.0 Tag: fox table question

dvidal

hi,

I need some code that asks if there is a field in a fox table and if it isn't, it must add a field to the table.

Thanks,

Top

Re: fox table question

dni

You may use afiels() function (or fldlist() for older vfp) to put in an array the filed list:

AFIELDS( ArrayName [, nWorkArea | cTableAlias ] )

http://msdn2.microsoft.com/en-us/library/aa977240(VS.71).aspx

then you may use ALTER TABLE (OR modi stru) to add fields:

https://msdn.microsoft.com/library/default.asp url=/library/en-us/fox7help/html/lngalter_table___sql.asp

Top

Re: fox table question

Alex Feldstein

The easiest way is to check the size of the field (0 if it does not exist).

Open the table EXCLUSIVE

If Fsize("mycolumn") = 0
Alter Table mytable add column mycolumn C(10)
EndIf

Conversely, if you want to delete it.

If Fsize("mycolumn") > 0
Alter Table mytable drop column mycolumn
EndIf

Top

Re: fox table question

Tamar E. Granor

If you go with FSIZE(), make sure you have SET COMPATIBLE OFF.

Tamar

Top