Passing an object to a webservice method.

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - build exe application Tag: Passing an object to a webservice method.
  - 2
    - Olecontrol with MS-Word Sir, I am using Visual Foxpro 6.0. How to open a ms-word file using with olecontrol. Also, can I edit the file and save it. Please give me all codes..... Roy MM Tag: Passing an object to a webservice method.
  - 3
    - Instance java classes from visual foxpro Hi, I have a java class that I want to instance from visual foxpro. There is a method inside my java class that receives a String and returns another String. I need to call this method from fox. How do I do this Thanks a lot. Tag: Passing an object to a webservice method.
  - 4
    - Errors running FoxPro Stored procedures in .NET windows app I warned you to check documentation:) Anyway I played with your SP code a bit: PROCEDURE PROCESS_LOCATION_VIEW_TABLES(tcDataPath) CREATE cursor __Temp (loc C(60), bill_date C(8), Total N(11,2)) INSERT INTO __Temp (loc, bill_date, total) ; SELECT order_id as loc, DTOC(order_date,1) as bill_date, order_net as total ; FROM orders WHERE cust_id like "A%" INSERT INTO __Temp (loc, bill_date, total) ; SELECT order_id as loc, DTOC(order_date,1) as bill_date, order_net as total ; FROM orders WHERE cust_id like "B%" INSERT INTO __Temp (loc, bill_date, total) ; SELECT order_id as loc, DTOC(order_date,1) as bill_date, order_net as total ; FROM orders WHERE cust_id like "C%" INSERT INTO __Temp (loc, bill_date, total) ; SELECT order_id as loc, DTOC(order_date,1) as bill_date, order_net as total ; FROM orders WHERE cust_id like "D%" CREATE table (ADDBS(m.tcDataPath)+"CollectDataFor201") FREE ; (loc C(60), bill_date C(6), Total N(11,2)) INSERT INTO CollectDataFor201 (loc, bill_date, total) ; SELECT loc, bill_date, SUM(Total) FROM __Temp GROUP BY loc, bill_date USE IN '__Temp' USE IN "CollectDataFor201" ENDPROC The selects in insert should be replaced with yours. They are there to show it works with this call (assuming testdata.dbc is in c:\temp\data). It's unnecessary to create __temp as a table. Also result table is better when it is a free table. No need to make that part of database: using System; using System.Data; using System.Data.OleDb; class SPsample { static void Main() { string strConn = @"Provider=VFPOLEDB;Data source=c:\temp\data\testdata.dbc;"; OleDbConnection cn = new OleDbConnection(strConn); OleDbCommand cmd = new OleDbCommand(); cn.Open(); cmd.Connection = cn; cmd.CommandText = "PROCESS_LOCATION_VIEW_TABLES"; cmd.CommandType = CommandType.StoredProcedure; OleDbParameter myPath = cmd.Parameters.Add("myPath", @"c:\temp"); bool result = (bool)cmd.ExecuteScalar(); cn.Close(); Console.WriteLine(result); } } Tag: Passing an object to a webservice method.
  - 5
    - Locking VFP rows from C# You have several options. -Use Mode attribute of connection string. You can set it to Deny Read,Deny Write or Share Exclusive. You'd be then updating with a file level lock. -Using VS6.0 (it contains VFP6.0) create a DBC and edit its stored procedures (in command: create database myDatabase modify procedures ) -Try a trick (not sure if would work, didn't try before from .Net) and add rlock() to your where clause. -Use transaction -If none works using StringBuilder write a script instead of a stored procedure, call the script as if it were a stored procedure (search here for the samples posted previously many times). Tag: Passing an object to a webservice method.
  - 6
    - FoxPro Views over VFP Oledb with VB? See this code by Borislav Borissov in the tek-tips forum about using Execscript as I suggested in my first reply: oAdoConn = CREATEOBJECT([ADODB.Connection]) oAdoConn.ConnectionString = [Provider=vfpoledb.1;Data Source=D:\All_zapl_4_9_0\;Collating Sequence=machine;] oAdoConn.Open() oAdoComm = CREATEOBJECT([ADODB.Command]) oAdoComm.ActiveConnection = oAdoConn oAdoComm.CommandText = [EXECSCRIPT("SELECT 0"+CHR(13)+CHR(10)+"USE Test EXCLUSIVE"+CHR(13)+CHR(10)+"INDEX ON Fld1 TAG Test")] oAdoComm.Execute() Tag: Passing an object to a webservice method.
  - 7
    - WORDWRAP How can i do to word wrap the header of the grid In Visual Foxpro version 7.0 it is possible but how about in Version 6.0 THanks Tag: Passing an object to a webservice method.
  - 8
    - Application reinstall using install shield. Thank you all for your comments, But: Am I to understand that the version of Install Shield shipping with VFP9 is by design not providing install-over or uninstall And on top of everything, it will install apps only in such a way were the user can't uninstall it from the windows add/remove utility Sounds more like a Spyware installer... Its pretty hard to believe Microsoft is capable of such a thing. Why would anyone want to use this tool if this is indeed the case Alen. Tag: Passing an object to a webservice method.
  - 9
    - Change Control Source of each detail line in a report Hello all, I have a report that has a Picture/OLE object in the detail band. The control source for each record could be different, so I have to some how change the control source of the Picture object for each record. The way I'm trying it now is I have a report variable setup like this: Variable Name: nCnt Value To Store: (nCnt + 1) Initial value: 1 Reset value based on: Report Calculation Type: None In the General tab of the properties of the picture object I have: Control source type: Expression or variable name Control Source: ADDBS(FULLPATH(""))+"detail"+ALLT(STR(nCnt))+".jpg" I'm using VFP 9 and in my ReportListener, I'm creating the image files in the Render procedure. The image files are created properly, but at one point, I ge an error saying "Invalid path or filename." Could someone tell me why this is happening Thanks. Tag: Passing an object to a webservice method.
  - 10
    - sql problem Hi, I used an sql clause in foxpro 7. I deleted some records with delete but I don't know how to commit these changes. If I write pack, it deletes all records. What can I do Tag: Passing an object to a webservice method.
  - 11
    - passing variables to reports without declaring them as public. I have programs that set variables for certain fields to print on reports. How do I pass variables to these without making them public My program is something simple like this: declare variables as public set variables depending on the user selections select table.* from table INTO CURSOR Confirm CREATE REPORT rname.frx FROM Confirm WIDTH 640 COLUMN NOOVERWRITE REPORT FORM rname TO PRINTER NOCONSOLE in the form rname I use the print when clauses to print certain things based on whether the variable is true or false. Thanks in advance Tag: Passing an object to a webservice method.
  - 12
    - create a key in registry le tan duc wrote: Please help me to create a key (Keyname='key name') in it: String name: (defalut) Type: REG_SZ Data: "Agribank" LOCAL lhKey, lnDisposition, lnResult, lcKey, lcVal STORE 0 to lhKey, lnDisposition lcKey = 'key name' lcVal = 'Agribank' # DEFINE HKEY_CLASSES_ROOT -2147483648 # DEFINE REG_OPTION_RESERVED 0 # DEFINE REG_CLASS_DEFAULT '' # DEFINE REG_OPTION_NON_VOLATILE 0 # DEFINE REG_SZ 1 DECLARE integer RegCreateKeyEx in Win32API ; integer nhKey, ; string @cSubKey, ; integer nReserved, ; string cKeyClass, ; integer nOptions, ; integer nSecurityAccessMask, ; integer nSecurityAttributes, ; integer @nKeyHandle, ; integer @nDisposition DECLARE integer RegSetValueEx in Win32API ; integer nKeyHandle, ; string cValueName, ; integer nReserved, ; integer nType, ; string cBuffer, ; integer nBufferSize DECLARE integer RegCloseKey in Win32API ; integer nKeyHandle lnResult = RegCreateKeyEx( HKEY_CLASSES_ROOT, lcKey, ; REG_OPTION_RESERVED, REG_CLASS_DEFAULT, REG_OPTION_NON_VOLATILE, ; 0xF003F, 0, @lhKey, @lnDisposition ) lnResult = RegSetValueEx( lhKey, "" , REG_OPTION_RESERVED, REG_SZ, lcVal + CHR ( 0 ), LEN ( lcVal ) ) RegCloseKey( lhKey ) Tag: Passing an object to a webservice method.
  - 13
    - Error on bmp I have one .bmp file what occur error when I install a new program of image, my .bmp file dosn’t work more. Tag: Passing an object to a webservice method.
  - 14
    - Using VFoxPro 9 and SQL to create a table You also need to remove the comma after UNIQUE. Think of the syntax this way: CREATE TABLE TableName ( ; <all information for field 1>, ; <all information for field 2>, ; .... , <table-level information>) IOW, no commas within a field definition. Tamar Tag: Passing an object to a webservice method.
  - 15
    - Visual foxpro and Navision c/odbc Has anybody any idea how to connect with VFP to an C/SIDE Navison database with the supplied C/ODBC 32 driver The notorious enexpected token error pops up every time No problem with Excel/access 2003 or Winsql But building reports in that stuff is rather too much work The problem is known on the Web. If possible please a tip If not possible please why not. Any experiences with Jet Report Thanks ahead, Robert Tag: Passing an object to a webservice method.
  - 16
    - File In Use Yes unfortunately it would work. Is there a solid reason you're packing so often Tag: Passing an object to a webservice method.
- Next
  - 1
    - Between "setfocus" and "gotfocus" - a magical disappearing act! Hi I have another odd situation (so far they seem to be the only situations on VFP that I suffer from!). In this one I have a text box on a form, and a button. The button click method calls another form that allows me to carry out a search. That part is really irrelevant - the search from returns a record number successfully - I can see that in the form in question and in other forms that use it. However, on this one form when I update the text box value with a field value from the returned record the contents seem to mysteriously vanish. I can see (by simple wait window commands) that it has retrieved the record successfully. I can see (again, wait window) that it has retrieved the field value. I can see on the form that the text box gets the value placed in it. I can see (by a wait window command in the setfocus of the text box) that it still has the value. and then the magic happens... because by the time it calls the gotfocus on the text box the value has reverted to what it was prior to the click method of the button. Are there any methods that fire between the setfocus and gotfocus of a text box I tried using a controlsource on the text box and setting that value and that did exactly the same as setting the text box value directly. As I said, I have this working on another form with no problems - the field is updated successfully. I have checked that I haven't duplicated the control source or that anything else is updating the control source, and I can't see anything. Any ideas Cheers Tag: Passing an object to a webservice method.
  - 2
    - Why is qeury so slow? Yes but the same code is slower in vfp9, so I think "JOIN" is slower in 9. You may write query without join for testing purpose. Tag: Passing an object to a webservice method.
  - 3
    - adding carriage return and line feed through foxpro oledb provider Using ado.net with the foxpro ole db provider I am trying to insert a record in the database that has a memo field. In the memo field I am trying to add some data seperated by a carriage return and line feed. Unfortunately, when I run it I keep getting a "Command contains unrecognized phrase/keyword" oledb exception. I have tried using string concatenation to add my parameter values to my query string and added in parameters using the " " but I keep getting the error. Any ideas on how to get this to work This is really frustrating. Tag: Passing an object to a webservice method.
  - 4
    - How to use the field validation rule? I put it in double quotes in the designer and it worked (e.g. validation worked immediatelly). Do you want to do it programmatically without validating old records Tag: Passing an object to a webservice method.
  - 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: Passing an object to a webservice method.
  - 6
    - Foxpro support library not found Ok I realized I should only need to download the VFP6 and VFP9 files - but after trying I get this error: Files that are required for Windows to run properly have been replaced by unrecognized versions. To maintain system stability, Windows must restore the original versions of these files. Insert your Service Pack 4 CD now. Tag: Passing an object to a webservice method.
  - 7
    - Will VFP6 work with Windows Vista See the January Newsletter from Milind Lele at http://msdn2.microsoft.com/en-us/vfoxpro/bb264582.aspx Microsoft are not even testing anything before VFP 8.0 for Vista - so you will be on your own unless you start thinking about the upgrade to VFP 9.0 REAL soon. Tag: Passing an object to a webservice method.
  - 8
    - Any way to print multiple copies of a report from within the reportlistener Check also http://support.microsoft.com/default.aspx scid=kb%3bEN-US%3b251236 Tag: Passing an object to a webservice method.
  - 9
    - My exe does not running other PC I will recommend you to use SETUP WIZARD instead of mannually copying those files. By using this wizard, you can create setup file that is used to install your program as any other windows standard program. Tag: Passing an object to a webservice method.
  - 10
    - search with option You may put in click on search button something like: Code Snippet IF FOUND() =.T. DO FORM CUSTOMER WITH thisform.TEXTBOX1.Value,thisform.TEXTBOX2.Value thisform.Release ENDIF *in form CUSTOMER init method you may put: PARAMETERS var1,var2 && var1 will be thisform.TEXTBOX1.Value,var2 = will be thisform.TEXTBOX2.Value Tag: Passing an object to a webservice method.
  - 11
    - Speeding up Foxpro - New Server - Multicore ? Xp V's Server Quote: "No Foxpro will not take advantage if operating system or bios does not have a "core manager". Too many Nos. Do you mean "Foxpro will not take advantage if operating system or bios does not have a "core manager". Tag: Passing an object to a webservice method.
  - 12
    - VFP Compiler for .NET Hi all, Stumbled across this company's web site and wondered what peoples opinion of it is: www.etecnologia.net They are currently building a .NET compiler that will take VFP syntax and compile it into IL code. Basically they state that you can write VFP code and run it within the .NET framework. They even state they are aiming at being able to compile existing VFP app's into .NET assemblies. For me this sounds very cool, even though I love C#, actually being able to code in my beloved VFP syntax in .NET would be a dream come true! Unfortunately I'm not convinced about this product. I have a few questions and concerns: 1) Would they ever achieve 100% VFP compatible code compilation 2) How well could the compiler be kept up to date with the CLR 3) What are the obvious short-falls of doing this Level of framework compatibility Would be interesting to find out the views of some of the more experienced .NET/VFP developers out there. NozFx Tag: Passing an object to a webservice method.
  - 13
    - Data deleted with ZAP When you do Zap in a table, a new table is created empty in another position inside your HDD. If you use a software for recover deleted files, you will find your old table and recover the data inside. I recommend to delete your new table since this new one could use sector of the older one. This only works if your Zap is recent. Tag: Passing an object to a webservice method.
  - 14
    - when should we use SQL command?? VFOX9 included most of the SQL command..... So when writing a program, should we use the VFOX command or use as much as the SQL command and Why should we choose between the two thanks! Tag: Passing an object to a webservice method.
  - 15
    - how to learn variable memory adress ??? If you need to pass the pointer to the address then try this: Code Snippet DECLARE integer GetProcessHeap IN WIN32API DECLARE integer HeapAlloc IN WIN32API integer hHeap, integer dwFlags, integer dwBytes DECLARE integer HeapFree IN WIN32API integer hHeap, integer dwFlags, integer lpMem lcString = "hello"+CHR(0) pHeap = GetProcessHeap() nHeapAddress = HeapAlloc(m.pHeap, 0, LEN(m.lcString)) SYS(2600,m.nHeapAddress, LEN(m.lcString),m.lcString) * m.nHeapAddress is integer pointer here HeapFree(m.pHeap,0,m.nHeapAddress) Tag: Passing an object to a webservice method.
  - 16
    - C++ to VFP Translation? I did look those over pretty well, and they do help in some things. Take this statement for example: if (DlPortReadPortUchar(STAT_ADDR)&0x20) I understand that STAT_ADDR is a parameter, but how the heck do you do add/concatenate/mash/smash/plug the "&0x20" so that VFP likes it Tag: Passing an object to a webservice method.

Tytow

Hi all,

I've been searching the net all day to find an answer to this
quesiton but I can't. Any help will be greatly appreciated.

I need to call a method on a webservice and I need to pass it an object.
What I've tried is something like this:

loInfo = CREATEOBJECT("empty")
ADDPROPERTY(loInfo, "ID", "1234")
ADDPROPERTY(loInfo, "Number", "5678")
(etc...)

then:

loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC\")
+"_ws3client.vcx")

loWebService = loWSHandler.SetupClient("TheCorrectURL", "Service")

llReturn = loWebService.CorrectMethod(loInfo)

This isn't an issue of connecting to the service. I can. I can call
methods that don't require parameters and get the boolean return value
fine. So... the bottom line is: how do you call a method from a
webservice that requires an object as a parameter

TIA

Top

Re: Passing an object to a webservice method.

CetinBasoz

Create it as an XML string and pass that one.

Check WSDL (and if .Net created asmx) if it requires a root node.

Top