Thanks Guitarzan.
I will have to ask our gateway provider if they include such a fingerprint. That is a valuable thing. I will continue to code my process page until further notice...
Cmcc
Thank you Olaf AND everyone for all of your responses. We are in the process of converting our Foxpro over to SQL now. I am creating a server side process that will exist on our server to check the value that is coming back from the client before heading off to the third party processor...
Thank you Chris. That is what I was thinking. Not sure if possible to make a form submit button disabled if they save the page.(or not allow them to save the page).
On our server, a value is determined what is needed to be paid. This information is then sent to a 3rd party payment gateway and...
...would send the user data to a third party processor.
echeckbtnmsg = " Pay $" + cstr(echeckdue) + " by eCheck (includes $.50 cent processing fee*)"
<form method='post' action= 'https://swp.paymentprocessor.com/co/default.aspx'>
<input type='hidden' name='pg_api_login_id'...
HI JRB-Bldr.
That makes alot of sense now! I couldnt understand what the association is between the fields. The first field in this table is a 'last updated date' field. SO! updated date were being updated. I am going to move the field (just to test) and see if only one record gets updated...
...of the table and any changes would reflect on the SQL table if a tableupdate is issued. (on buffering = 5).
Thanks for all your help.
************************************************************************************** Open_SQL_View returns the current work area
* dbf_FileName is the...
There are no relations. There are no joins.
The primary key is the customer number which is 'cust_num'
This is the only table I am trying to update and the name 'npmaster' means it is the master customer table (not a master/child table).
We are not using SQL server in the traditional fashion...
lookup form - load event:
SELECT tname, notes, tstatus, lastupdate, cust_num;
FROM npmaster;
INTO cursor grdname
**** this cursor is recordsource for the grid
lookup form - "Find Customer" button click
SELECT grdName
INDEX ON tname TO who + "tname"
Set Order To who...
...set. Once found in this cursor, I send to another form with a customer number, then close this particular cursor.
In that detail form, I select * from the live table where livetable.customer number = the customer number parameter into a one record cursor . This cursor populates the text...
HI All.
Working in vfp9, with SQL backend. Creating remote views. When a customer record is changed, the fields that were selected for change (say name and zip) are being updated multiple times for different 'customers'. so when I change a zip code to '88888' for that one customer, it varies...
Hi George.
Its actually so old school that it is a standalone .DBF 'lookup table' - in the process of converting data to SQL Server 2008.
Hi Chris -
let me try what you are suggesting and let you know the outcome! Thanks so much for both of your expertise!
CMCC
...oConn.ConnectionTimeout = 120
oConn.CommandTimeout = 120
oConn.open "DSN=SCTC_TEST;"
sel = "Select * from arh where cust_num like '" _
& SearchString & "%'"
I have tried Cint(SearchString), I have also tried making the field in the DB a character...
Thanks to both of you for your help. Im only alittle familiar with AJAX, so I will definitely check out that tutorial link that you provided Jeepxo.
The need for it isnt as important as it was when I posted, but it is helpful to know how to - in case I need it in the future!
CMCC
Hi all.
I have a form where the action is a link to a third party vendor for credit card payments. Within this form, I attach hidden variables and submit those with the action to the link.
We want to start adding records to a table to let us know when a customer has "left" our site to go to...
Thanks JRB-Bldr! I guess I didnt phrase my question quite correctly, but I will keep your suggestion in mind for when I have multiple forms that need altering. I must start using the class effect when starting a project (as Tamar suggested) - sometimes I forget to do that.
Cmcc
Thank you Mike. I realized that I would have to run that again, but your suggestion would work for all instances- with no need to run again - in case I forget.
I love this site!!!
Cmcc
I have a form with 6 tabs on a pageframe, and would like to set all the maxlengths to 100 for all textboxes on the form without having to go into each and every tab and each and every textbox property to set.
Is there someway to do it, sorta like closing forms all at once:
lnFormCount =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.