Sedang Disiapkan

Find and Replace Applications - Modify FoxPro Tables

I need 2 find and replace applications created to modify FoxPro tables.

Application 1 – Replace the part number, part description, part alpha number & part cost in the “[url removed, login to view]” table. Only the records where the takeoff numbers match the takeoff numbers in the “Takeoffs to [url removed, login to view] file” will be updated. The old part numbers will be replaced with the new part numbers based on the information in the Parts to [url removed, login to view] file. The part description, alpha part number, and line cost will be updated for the new part number based on the information in [url removed, login to view] file for the replacement number.

1. Search for the old part# and change it to the new part# for the selected takeoffs

a. In the “[url removed, login to view]” table, FOR each record WHERE ([url removed, login to view] = “Takeoffs to [url removed, login to view]” SHEET1, Column A) AND ([url removed, login to view] = “Parts to [url removed, login to view]” SHEET1, Column A) REPLACE [url removed, login to view] with “Parts to [url removed, login to view]” SHEET1, Column B

2. Update the [url removed, login to view], [url removed, login to view] AND [url removed, login to view] fields from the “[url removed, login to view]” table.

a. In the “[url removed, login to view]” table REPLACE ([url removed, login to view] WITH [url removed, login to view]) AND ([url removed, login to view] WITH [url removed, login to view]) AND ([url removed, login to view] WITH [url removed, login to view]) WHERE (tkflin.prtnum=[url removed, login to view])

Application 2 - Replace the part number, part description, part alpha number & part cost in the “[url removed, login to view]” table. Only the records where the assembly class does not match the assemblies not to update numbers in the “Assemblies not to [url removed, login to view] file” will be updated. The old part numbers will be replaced with the new part numbers based on the information in the Parts to [url removed, login to view] file. The part description, alpha part number, and line cost will be updated for the new part number based on the information in [url removed, login to view] file for the replacement number.

1. Search for the old part# and change it to the new part# for all assemblies except for those in the class selected.

a. In the “[url removed, login to view]” table, FOR each record WHERE ([url removed, login to view] = [url removed, login to view]) AND ([url removed, login to view] <> “Assemblies not to [url removed, login to view]” SHEET1, Column A) AND ([url removed, login to view] = “Parts to [url removed, login to view]” SHEET1, Column A) REPLACE ([url removed, login to view] with “Parts to [url removed, login to view]” SHEET1, Column B)

2. Update the [url removed, login to view], [url removed, login to view], AND [url removed, login to view] fields from the “[url removed, login to view]” table.

a. In the “[url removed, login to view]” table REPLACE ([url removed, login to view] WITH [url removed, login to view]) AND ([url removed, login to view] WITH [url removed, login to view]) AND ([url removed, login to view] WITH [url removed, login to view]) WHERE (asmprt.prtnum=[url removed, login to view])

Alternatively, the applications can be created to get rid of the excel sheets, and have the user enter the information into selection fields within the application.

Kemahiran: Visual Foxpro

Lihat lebih lanjut: find replace foxpro, foxpro find replace, foxpro replace, foxpro search replace, foxpro replace file, modify foxpro, dbf replacement, search replace records foxpro, find replace applications, replace change foxpro, in visual foxpro, $ in visual foxpro, find on-line, find it application, cost of applications, takeoffs, replace, foxpro, dbf, assemb, applications, find user, selected records, excel column update, foxpro application

Tentang Majikan:
( 1 ulasan ) Southampton, United States

ID Projek: #1549624

Dianugerahkan kepada:

marioalonzo

Greetings My experience includes several years working with FoxPro, starting with D.O.S. version 2.5, up to the Visual version 9.0. Also, I have made software conversion from FoxPro D.O.S. to Visual FoxPro. I prop Lagi

$130 USD dalam 7 hari
(2 Ulasan)
2.9

10 freelancers are bidding on average $184 for this job

costin77

As a professional software developer, I have more than 12 years of experience in software development, specially in VFP. I developed all kind of projects, from small desktop application to medium sized and large applic Lagi

$140 USD dalam 3 hari
(1 Ulasan)
3.9
chetanraj81lx

See pmb for more information

$250 USD dalam 3 hari
(2 Ulasan)
2.7
ahmedmayeen

Hi, I sent my formal bidding cover letter as a private message, please refer to that. Regards, Mayeen

$220 USD dalam 2 hari
(0 Ulasan)
0.0
luknet

Hi, I have experience in FoxPro and Visual FOxPro, SQL for 12 years and I understand what you need. Regards, Lucian

$150 USD dalam 3 hari
(0 Ulasan)
0.0
MohanParamane

Hi, We are Pune (India) based company working since 1996. We will complete your work in time. We provide online support for software and customer satisfaction is our goal. Regards

$200 USD dalam 10 hari
(0 Ulasan)
0.0
vfox

30+ years of database experience. dBase, foxbase, foxpro, visual foxpro

$250 USD dalam 2 hari
(0 Ulasan)
0.0
imran82ali

I can do it easily. Just confirm your bid. Think Done !

$200 USD dalam 20 hari
(0 Ulasan)
0.0
rob5699

Why not do both. You can either manually enter the rec. # and part # or do a mass replacement with excel file or if you want to a csv (common separated value) file. This way if you have only one or two that needs to b Lagi

$150 USD dalam 2 hari
(0 Ulasan)
0.0
tassee

I'll be happy to complete your project's tasks

$150 USD dalam 2 hari
(0 Ulasan)
0.0