FiveTech Software tech support forums

... that customer and the CUSTNO gets added automatically to the reservation database. CUSTOMERS.DBF FIELDS: CUSTNO (primary key, unique) FIRSTNAME LASTNAME RESERVS.DBF FIELDS: (You could have multiple reservations for the same CUSTNO) RESERVNO (primary key, unique) CUSTNO RESERVITEMS.DBF FIELDS: ...

... {"status":200,"data":[{"customerId":1,"gender":"","firstName":"Marc","lastName":"Venken","dob":"0000-00-00","emailAddress":"marc@maveco.be","addressBookIds":"2","defaultBillingAddressId":2,"defaultDeliveryAddressId":2,"phoneNumber":"89853445","faxNumber":"","bankAccountNumber":"","subscribedToNewsletter":"0","guestAccount":1,"approved":1,"discountGroupId":0,"discountGroupName":"","groupDiscount":"0.00","numberOfLogins":1,"lastLoginDate":"2014-09-11 ...

... I wish insert Alan (as first) and Joe( as Last) when I insert "Alan" it return me "Alan" exist and then I cannot insert the lastname here the test sample #include 'fivewin.ch'#include 'xbrowse.ch'REQUEST DBFCDXREQUEST DBFFPTEXTERNAL ORDKEYNO,ORDKEYCOUNT,ORDCREATE,ORDKEYGOTOfunction ...

Hi, With MSSQL i do this : csql:="INSERT INTO "+(cTabla)+ " (PATID,LASTNAME) VALUES (" cSql:=cSql+" 'C01', 'CONCEPTO PARA PRUEBAS'+" )" TRY oCon:Execute(cSql) CATCH oErr ShowAdoEr( oCon,csql ) END TRY Hope it will help ! Philippe

... USE CUSTOMER XBROWSER "CUSTOMER" COLUMNS "FIRST","LAST" SETUP oBrw:cHeaders := { "FirstName", "LastName" }

... Because I still need the data of old customers I don*t delete them instead I move the data to the bottom adding "Z_" to the customer lastname ( index ) and "Z" to the customer number ( index ) like name : "Z_Maier" and number "Z0035" I can activate the ...

Hi dutch

It wont work... I dont know if the customer is going to enter only the name or both name and lastname.
And it could be any of the fields in a xbrowse, it is created dinamically

The only problem I see, is the space in between the variable you pass to the filter ???

Dear Adolfo, If you use FWMARIADB, You can use :SetFilter() as xbase syntax. oDbDato:SetFilter(" 'LASTNAME' $ nombre ") or exactly oDbDato:SetFilter("nombre=?",{"ADO"} )oDbDato:ReFilter( {"SMITH"} ...

Nages...

oDbDato:SetFilter("nombre like '%NAME LASTNAME%'") does not work.
Only oDbDato:SetFilter("nombre like '%LASTNAME%'") works, each time a space is in the filter, it does not work.

Any tip or advice

From Chile Adolfo

... If the browse is something like: @ r,c XBROWSE ..... COLUMNS "FIRST", "LAST", ......... HEADERS "FirstName", "LastName", ....... Then condition like oBrw:FirstName:Value = <something> is better than oRs:First value or oRs:Fields( "first" ...

... "UserDetails": { "ContactID": 674, "AgentID": 184145, "FirstName": "UAT", "LastName": "APIUser", "Email": "UAT.apiuser@company.com", "JobTitle": "Software Application", ...

... but the real purpose is this. The sql statement creating the rowset could have used alias names for the fields, eg: FIRST AS FIRSTNAME, LAST AS LASTNAME, HIREDATE AS JGDATE, etc. The rowset displays the alias names only eg. FirstName, LastName, JgDate, etc but not the original field names of ...

Hello,
Is there something new about this ?
How to extract FirstName,LastName,BirthDate etc
Thanks for your help .

Please try oBrw:bLDClickDatas := { || oBrw:EditSource( .f., "FirstName,LastName,PhoneNumber", .f. )} XBrowse internally invokes TDataRow class to edit the contents of the fields and save them properly and update xbrowse. I assume the recordset ...

... a table of Customer from a MS SQL database. I do not want to use autoedit . When the user dblclick on a line, i open a dialog and ask FirstName,LastName, PhoneNumber. When the user click on save, i can do an UPDATE SQL instruction but when i come back in the XBROWSE, the new value is not Displayed ...