Upsizing to Firebird

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - Grid class I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). Tag: Upsizing to Firebird
  - 2
    - uniqueness of index <insert index name> is violated. Hi, i'm making batch changes to several of our foxpro databases using C# and ado.net. Basically i am consolidating many lookups into the same key across multiple databases. After moving them to the proper id and deleting unused id's, i go and find out from all of the databases what lookups they have, compile them into a uniquelist and then make sure that every database has that row. My problem is that once my consolidation happens and it deletes unused rows, i'm trying to add rows that use to be there back in because they're part of my 'master list' and i need them even though they aren't being used... i then get this error even though the record has been deleted already. example id 9060 was not being used, i first go through and delete all codes that aren't being used in related tables (to clear out all of the junk --and unfortunately in some cases codes i need to keep around as well) 9060 was deleted I consolidate all of the codes i go to my master list and try to add 9060 again with it's proper description (one that matches the master list), and i get the uniqueness error. Now, i could go back and rewrite the whole architecture of my software to support this 'bug ' but i'm hoping someone knows a way to rebuild the indexes programmatically (in ado.net) so i don't have to. Thanks! Tag: Upsizing to Firebird
  - 3
    - What fires first Init() or Load() Does the Init() procedure of a form, fire before the Load() procedure of the form. I am trying to use a SQL Select in the Load() of a form with a passed form property from a ComboList box [a value set within it's Init()]. I had hoped to initialize the passed property before the Forms Load() event and its SELECT-SQL ran, then optionally let the user select different values in the ComboList box and then have it call the Load() event when the user changes the selection. I am not sure of the event firing sequence. Thanks in Advance Richard Tag: Upsizing to Firebird
  - 4
    - VFP7 crashes with "Fatal error: Exception code=C0000005" during data import from Excel I'm using the following statements for reading from a multiple-sheet Excel file: CREATE CURSOR Main (ID N(3,0), SUBID N(3,0), DESC C(60), D C(128), E C(10), F C(10), G C(10), H C(10), I C(10), J C(10), K C(10), L C(10), M C(10), N C(10), O C(10), P C(10), Q C(10) ) APPEND FROM (cFile) TYPE XL5 SHEET "cSheet_n" with cSheet_n = sheet names of the current spreadsheet. The tables had been saved as Excel5.0 workbooks. Typically 100 rows are being read per sheet, typically 5 to 10 sheet per file in total. If the table is somewhat larger or contains more commenting text within the columns E (from which I read 10 chars only), the procedure tends to crash, but astonishingly this isn'z really reproducible (sometimes on the 1st sheet, sometimes on the 4th only)! I tried out with XL8 instead of XL5 -> no difference. If I replaced all formula in the sheet by the values, it behaved better, but not clearly stable (still crashing sometimes). What's wrong Tag: Upsizing to Firebird
  - 5
    - FoxPro 8 where to find information My computer died. Reload OS. I have one FoxPro program, used for over 7 years. and still have the database - reinstalling the OS only affected the boot WINDOWS partition. But the FoxPro program, which I can access, will not run - cannot find a required DLL. Where do I go for help in this kind of situation. I am sorry to ask such on FoxPro 9, but where else is there Tag: Upsizing to Firebird
  - 6
    - Run /N *.CHM file we can't : RUN /N c:\help.chm Please help me to sovle the problem thanks Tag: Upsizing to Firebird
  - 7
    - Copy to delimited Hi, I need to be able to create a standard ASCII file delimited with tabs. However the default for the command: COPY TO file .txt DELIMITED WITH TAB produces the character " wrapped around all fields. Does anyone know a way of producing a standard tab delimited file without the " characters Cheers, Paul. Tag: Upsizing to Firebird
  - 8
    - Outlook contact details This might not be the right forum for this question given that it mainly concerns Outlook (although I am accessing it from VFP), but I am hoping that one of you smart and helpful people may know the answer ... I am trying to obtain to populate a VFP table with the details that I can see in my Outlook 2002 address book. I have had some success at obtaining details such as Name, Email Address and Type via the AddressEntry objects in the "Global Address List" AddressList object. But there are numerous other details which I can see in the Outlook Address book but which I have been unable to obtain programatically: First Name, Last Name and Address (on the General tab); various phone/fax numbers (on the Phone/Notes tab) and numerous email addresses (on the E-mail Addresses tab). Can anyone tell me where I can obtain these or at least point me in the right direction Tag: Upsizing to Firebird
  - 9
    - "Flush" vs. "Tableupdate(1,2,.T.)" ? The question is: When is it wiser to "flush force" (data to disk) vs. =Tableupdate(.T.), =Tableupdate(1), etc. What is the usual paradigm Can I forget flush Is flush slow in the LAN setting(s) Does flush hog resources Does frequent-flush help prevent corrupting tables during intense LAN data-manipulation, crashes, and/or power outs Is is dangerous to rely too much on Tableupdate() alone when tables stay open all day As always, thanks in advance for any thoughts Tag: Upsizing to Firebird
  - 10
    - Change of Class Library ... Hi, I have been using a base class library ( say X) for my application development. Now that I've created a new base class library (say Y). I want to change the class library for all the objects (in all forms in my project). I wrote a small program something like Code Snippet mscx_ct=Adir(mscx,'*.SCX') mct=1 do while mct<=mscx_ct mfnam=mscx(mct) use &mfnam repl all classloc with "Y" mct=mct+1 use enddo The above code works fine with objects which are not contaiers. For container objects like command group , the member class location needs to be changed. Please let me know a procedure to change it if exists. Best regards, Markish Tag: Upsizing to Firebird
  - 11
    - ODBC Driver I'd best start this thread by admitting I know less than nothing about FoxPro so dummy answers would be appreciated. I have a customer who is connecting software I have written to a foxpro database via ODBC. The customer has created a System DSN using the Microsoft Visual Foxpro Driver v6.00.8167 that points to a "free table directory". My software simply runs a query on a table (Details.dbf). The software works fine until the number of records hits 10K+. At this stage each single query (which only returns one record) takes at least 5 seconds to execute. At first thought I figured the peformance was down to a lack of indexes on the table. They have since added several indexes with no improvement in performance. My suspicion is that the ODBC driver is not using the indexes. Can anybody shine any light on this and suggest possible solutions to this extremely poor performance Tag: Upsizing to Firebird
  - 12
    - BUG: Microsoft Visual Fox Pro ODBC Driver (6.1.8630.1) The bug is: driver doesn't support autoincrement fields: while trying to use any table, contains autoincrement fileld, the exception "Not a table." is thrown. Tag: Upsizing to Firebird
  - 13
    - Performace issues over VPN / Terminal services. Hi everyone; I have tried today to connect via VPN over DSL lines to a remote system and run my VFP application. Perfomance sucked big time, but I wasn't surprised. Using remote desktop to the win2003 server is very fast for obvious reasons. My question: - Did anyone here use VFP over VPN when the application is not client/server but rather VFP files on a remote server Is there any way to get reasonable performance in a WAN connection I will post my second question in a seperate thread. Thanks. Tag: Upsizing to Firebird
  - 14
    - 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: Upsizing to Firebird
  - 15
    - A couple questions about the OLE DB data provider Hello! I'm looking to access a VFP database from an ASP.NET web application and I have a couple questions about the OLE DB data provider. 1) Can I use the latest VFP 9.0 OLE provider with a VFP 6.0 free table directory Should I expect any problems 2) Does the OLE DB provider have any dependencies on VFP E.g. could I install it on a machine without VFP and still be able to manipulate my data files Thanks in advance! - Matt Tag: Upsizing to Firebird
  - 16
    - Why my VFP exe file cannot be launched? I complied my program under VFP6 into an exe file in the program folder. But it cannot be launched. I believe there is nothing wrong with the code, because I just made a minor change. The funny thing is that if I copied the file to other folders on the same drive, it works! And even more wear is that some old version VFP exe files could not be launched from within that program folder, either. I have to copy them out to test. It only happens to VFP exe files. Other exe files are OK. It did the same with VFP9. Any idea what could be the problem Tag: Upsizing to Firebird
- Next
  - 1
    - Parameters in a VFP method Hi All, I want to use PARAMETERS in a VFP method. How can I achieve this. Example: In a method called MyMethod FUNCTION getperiod(ldDateIn, lnPeriodIdIn) SELECT myTable SELECT periodid FROM myTable WHERE DateIn = ldDateIn AND PeriodIdIn = lnPeriodIdIn INTO CURSOR myCursor RETURN PeriodID (Which in this case is a numeric value) Thanks for any help or insight. Regards, Dave Tag: Upsizing to Firebird
  - 2
    - Using VFP6 to hide sheets and protect book in excel I used a program to copy results of a query into an excel sheet. Now I would like to hide two sheets that I renamed in the program - 'High' and 'Med'. I would also like to protect the book. How can I do this Is this even possible Some sample coding below: esheet=1 loExcelTemplate.sheets[esheet].select oActiveSheet = loExcelTemplate.ActiveSheet oActiveSheet.name = "High" &&RENAME CURRENT WORKSHEET loExcelTemplate.Columns("A:Z").EntireColumn.AutoFit loExcelTemplate.ActiveWorkbook.Save loExcelTemplate.Visible = .F. loExcelTemplate.Application.Quit Release loExcelTemplate Tag: Upsizing to Firebird
  - 3
    - "Multiple-step operation generated errors. Check each status value." I am getting the following error when trying to update an existing Foxpro database using the VFPOLEDB.1 provider and ADO: "Multiple-step operation generated errors. Check each status value." I have tried about every combination of cursor types and locations but cannot get it to work. Here is my code: Dim ADODBConnection As New ADODB.Connection() ADODBConnection.ConnectionString = "Provider=VFPOLEDB.1;Data Source=F:\xmgmt\data\client.dbc" ADODBConnection.Mode = ADODB.ConnectModeEnum.adModeReadWrite ADODBConnection.Open() Recordset = New ADODB.Recordset With Recordset .ActiveConnection = ADODBConnection .CursorType = ADODB.CursorTypeEnum.adOpenDynamic .CursorLocation = ADODB.CursorLocationEnum.adUseClient .LockType = ADODB.LockTypeEnum.adLockOptimistic .Open( "SELECT recordnumber FROM [events] WHERE recno <=0" ) End With Dim CurrentRecordNumber As Integer = 0 While Not Recordset.EOF CurrentRecordNumber += 1 Recordset.Fields.Item( "recordnumber" ).Value = CurrentRecordNumber 'The field 'recordnumber' is of type 'Numeric' Recordset.Update() 'This is where I receive the error Recordset.MoveNext() End While Any help would be greatly appreciated. I have searched all over the web for any answer but have come up with nothing. Steve Tag: Upsizing to Firebird
  - 4
    - Forum Usage Since this thread has gone off-topic, may I please ask few questions about this forum usage. 1) How can I see replies in the chronological order E.g. I only want to see the latest replies but I can not figure out how to do it. 2) Can I turn off Alerts for good I often forget to uncheck them when posting a message. 3) Why most of the messages appear in a very small unreadable font and how can this be made better 4) Why quite often the latest replies do not appear for quite a long time, as it was few days ago Thanks a lot in advance. Tag: Upsizing to Firebird
  - 5
    - Funny behavior of alignments in report designer. Hi; Not sure if I'm missing something here but here's the situation: I have a report with some numeric values in the detail band. For some reason, although in the report the headings and the numeric values are both nicely aligned to the right, once I run the report all headings are 1 char too much to the right. The format of the numeric values are all 'numeric' and no more options selected. I've also tried a few fonts and nothing helps. Has anyone experienced this Thanks. Tag: Upsizing to Firebird
  - 6
    - Need help with report expression I want to evaluate two fields before I include it in my report. I'm not sure if what I have is correct, can someone help me with the syntax: IIF(EMPTY(grntradd) OR ISNULL(grntradd) OR PROPER(grntradd)=PROPER(mailaddr),"Not Available",PROPER(grntradd))) Thanks, Jennifer Tag: Upsizing to Firebird
  - 7
    - build exe application I am a neophyte FoxPro programmer, AND I am new to forums such as this, so please bear with me. I have been using a simple program utilizing a few free tables and some report forms, which I have been running within FoxPro. Now I want to generate an exe version for distribution to other computers in my area without installation of FoxPro at those locations. I have used the build command from the project manager, and it performs the build with no report of errors. An exe file results, as expected. The runtime files (vfp9r.dll, vfp9renu.dll, gdiplud.dll, and MSVCR71.dll) have all been copied into the same directory as the exe file. However, when the exe file is then clicked, nothing visible happens. The exe file appears in the Windows Task Manager list of processes, but not in the list of running applications. On the other hand, if the exe file is called from within the FoxPro command window, the exe application launches and runs perfectly. Is there something obvious which I have done incorrectly Thanks to anyone who can advise me. Lowell Tag: Upsizing to Firebird
  - 8
    - Will VFP6 work with Windows Vista My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. Tag: Upsizing to Firebird
  - 9
    - Too many report copies Hi, I have a VFP9 app where the users can check off multiple reports to print (often 4-6) and then set via a screen the number of copies each (often 3) and then just say "Print them" (this is all VFP code). To handle this and free up their machine immediately, I have passed off report generation and printing to a server. This works most of the time but regularly the users complain that they get the wrong number of copies or even worse, they get a humungous amount of copies of one of the reports (usually until the printer runs out of paper e..g they asked for 3 copies but they end up getting 50 copies). The printers are HP 2430n printers and I have tried a) the newest HP 2430n PCL6 driver b) the latest HP 2430n PCL5e driver c) older drivers d) the HP 2430n PS (Postscript) driver. And so far, none have solved the problem. It seems like the server is getting hung up on a job and just keeps resending it. Any ideas Albert Gostick Tag: Upsizing to Firebird
  - 10
    - report generation i've ben trying to solve this thing for quite some time now, can't seem to figure it out. here's the scenario i'm working with 4 tables. table1 - personal data (first name, middle name, last name, file no.) table2 - stations/branches of the company (division1, division2, division3, file no.) table3 - physical exam (date_evaluation, examiner, date_evaluation_submitted, file no.) table4 - psychological exam(date_evaluation, examiner, date_evaluation_submitted, file no.) the file no. in the 2nd, 3rd and 4th tables are based on the file no. from the first table. the user input will be 1. option1 : as of date (will be compared with date_evaluation of physical exam) option2 : period covered - from date a to date b (will be compared with date_evaluation of physical exam) 2. option1 : Alphabetical option2 : by division it would have been easier to use sql query but i can't seem to insert the values in a cursor. i need to grab the data from the cursor for the report. here's how it goes... user will choose from the first options (this will decide which data will be retrieved) the second options will determine the order by which data will be displayed. hope you can help me out guys... thank you. Tag: Upsizing to Firebird
  - 11
    - Disable right click event Hi All Is there any way to disable mouse right click in web browser control e.g. I have a web browser control on my form to display web pages. but I need that if user right clicks on web control then no default menu be shown to user but simply a message that "You don't have permission to right click here" will be shown. Tag: Upsizing to Firebird
  - 12
    - GETPRINTER() causes access violation in VFP6R.DLL Hello, We have a Visual Foxpro 6 application used on several computers. On one machine, and only this one, one of the report often crashes with the error "access violation in VFP6R.DLL" The computer configuration is: Windows XP sp 2 Visual Foxpro 6 executable Other computers using the same report have no problem. I`ve read on this forum and on other newsgroups that it may be caused by memory corruption in the form initialization/loading events but I`m quite at loss on why on this machine it will crash 8 times out of 10 and never on the others. I`ve narrowed the culprit code to the GetPrinter() line. The dialog is not shown, something happens while the Foxpro environment grabs the printer defined on the computer. Thanks in advance to anyone who has a suggestion, Eric Tag: Upsizing to Firebird
  - 13
    - slipstream VFP 9 with SP1 ? Anyone know how to slipstreaming Visual FoxPro 9 with current SP1 Tag: Upsizing to Firebird
  - 14
    - report preview window is not displayed Dear friends, I use vfp 6. I have a form with a command button. In the click event of the button I have used "r eport form xyz prev" command. But when i click it, preview window is not displayed and only its toolbar appears on screen. I opened report in report designer and clicked on File -> Print Preview. At this time preview is displayed but not when clicked on command button. please help........ Tag: Upsizing to Firebird
  - 15
    - Get column name in SQL query How can i obtain all the records in a specific column like: select field1 from table but instead of the name "field1" use a column number i'm guessing : select 2 from table // The number 2 being the third column (starting at 0)... is this the right way Thanks. Tag: Upsizing to Firebird
  - 16
    - about vfp9 sp2 does vfp9 sp2 have bugs a month ago,I installed sp2,but when I closed the cursor (got by SQLexec() from SQL Server),the IDE opened a dialogbox containing mistakes,then the vfp9 IDE closed right away, Tag: Upsizing to Firebird

ionutp

Help me to upsize a database to a Firebird database.

Re: Upsizing to Firebird

Alex Feldstein

Never used Firebird but it should not be much different than any other database server work.

Connect to Firebird:
Driver=Firebird/InterBase(r) driver;Uid=myuserid;Pwd=mypassword;DbName=D:\FIREBIRD\data\mydata.FDB;

See: http://www.connectionstrings.com/ carrier=firebird

Then it is a matter of either inserting the data into the proper tables.

If Firebird has a data-transfer facility like SQL Server's DTS, then it is easy to just create a transfer package (script) and going from DBF to Firebird tables of the same structure.

Hopefully somebody else has direct experience with Firebird and can give you more detailed steps.

[Update]: You can download the latest ODBC driver from:

http://www.praktik.km.ua/

See also expamples you can download from that page

Re: Upsizing to Firebird

dni

You may also check:

http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/dac2edfd-d7a9-4f83-8ab7-bd54afa0d0b9.asp

Re: Upsizing to Firebird

ionutp

The link only shows upsize to SQL Server.

Re: Upsizing to Firebird

dni

I know, but I am afraid you will need to build your own migrate code using SQL(Firebird is SQL "flavor") model, or use a third party software, or yuo can migrate to SQL and then to Firebird....

http://www.firebirdsql.org/manual/migration-mssql.html

Re: Upsizing to Firebird

Naomi Nosonovsky

See if tools from http://vfp.softalizer.com/ may be helpful