Recent content by wsobers

Thanks for the reply, I did some more research and got some information from here: "http://foxcentral.net/microsoft/WhatsNewInVFP9_Chapter10.htm" that gave me exactly what I needed. I am producing an XML file using another DB product to be loaded by Foxpro using the XMLAdapter class and I...

I need to export data from a remote system to Fox to generate reports. I can generate a schema file and data files separately, but I want to be able to pass single file containing both schema and data. Does anyone have an example of this? Or can someone point me in the right direction. Wayne

I have a Magicard Opera Card printer. When trying to print to it I find that the Page margins are set and fixed at 1 inch. Does anyone know how to change these margins? Fox 9.0 SP1 Wayne

Jim, Thanks for the pointer. It worked great for what I want to do. There is one more question, I find I have to assign the PictureVal property to get the image control to refresh, rather than just have the PictureVal Property set on the Property sheet. Is this normal, or am I missing something...

I have created a cursor with a general field. Basically its a list of names with a JPEG or GIF image for each name. I want to be able to display the image from the general field on a form. I have done this using the file name technique, but in this instance I ( or rather Management) do not want...

Olaf, The problem you describe is exactly why I tried to use the DE in the first place. I used Foxpro way before the DE was added to the product and I always pre-generated the data into a single cursor because: a) If there where problems with the report I could put the cursor data into a table...

Here is the class I ended up with. *File: orderdde.prg define class orders as DataEnvironment * initialselectedalias = "orderd" * procedure init do ordload this.opentables() endproc procedure opentables select orderh index on orderno tag orderno select orderd index on orderno tag...

Olaf, there are no databases involved. What I am doing is creating cursors on the fly and populating them with data from XML and CSV sources. In some cases the data is being passed via OLE/COM interfaces. I want to avoid explicitly creating temp tables on the users machine which is why I am...

I build my reports by generating cursors first and then running the report form. I was hoping to run the cursor generation code in the init or opentable event of the DataEnvironment, but it seems as though the DE needs to reference file based tables and cannot use in-memory cursors. Can anyone...

Mike, I tried "{^YYYY-MM-DD}" as well, but no luck. Pamela, Given that I am using an ADODB Command object, I'm not sure how to go about setting this up. I'll have to do some more research on this. Thanks for replying... Wayne

cInserFields is like this:- [Account,CustName,Rate,Address] cInsertValues is a string somewhat like: [1345,"Fred Bloggs",5.87,"1 Random Way"] so the final string looks like... "insert into xrtlparts (Account,CustName,Rate,Address) values (1345,"Fred Bloggs",5.87,"1 Random Way")" This works for...

I have to update/insert records into a VFP free table. Code follows below... Dim Conn As Variant Dim sql_cmd As String, qry_cmd As String ' Set Conn = CreateObject("ADODB.Connection") Conn.Mode = 16 ' ShareDenyNone Conn.CursorLocation= 3 'Client Side Cursor Conn.Open "Provider=VFPOLEDB;Data...

Thanks Mike, I'll repost in the other forum. Wayne

I have to update/insert records into a VFP free table. Code follows below... Dim Conn As Variant Dim sql_cmd As String, qry_cmd As String ' Set Conn = CreateObject("ADODB.Connection") Conn.Mode = 16 ' ShareDenyNone Conn.CursorLocation= 3 'Client Side Cursor Conn.Open "Provider=VFPOLEDB;Data...

I have implemented the "auto-fill" combo box from faq184-1812. In the GotFocus Event, I change the background color and call 'dodefault()' If the combobox does not have focus and i click on the combo down arrow, the cursor moves into the combo box but the list does not drop down. It then...