Clarion and WinDevMobile

Startbeitrag von JasonSixface am 18.07.2013 15:54

For those clarioneers,
I hope you can give tips on this simple small project.

I only have 2 files:

Order header
- OrderHeaderID
- OrderDate
- CustomerName
- ContactNo
- Notes
- BalanceBF
- Total
- AmountPaid
- Balance

Order Detail
- OrderHeaderID
- OrderDetailID
- ProductName
- Qty
- SellingPrice
- Amount

I have created a clarion software to keep all the customer and product database in tps as well as have orderheader and order detail in tps too.

My task is:

1. to create a daily order records for each customers with preloaded product list with selling price accordingly.
2. transfer this data to a SQLite data.
3. transfer this sql data to a tablet running on android jelly bean 4.1
4. the user will key in the value such as product qty and amount paid and save it.
5. the system should retrieve those data from tablet and transfer into the clarion software via sql lite odbc

Now, i have created windev mobile 17 windows for order list, order form and order detail form.

Order list will show the order header records.after selecting the order, it will open the order form. My problem starts here,
a) I dont know how to link the child looper (order detail) which is populated in the order form linked to order header.
b) where is the data located in the tablet? how to retrieve it?
c) i have read the article that i need to create hypersql in analysis but convert it into sql lite via code. is it necessary?

please help
thanks in advance


Zur Information: hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.