generate SQL UPDATE statements automatically
Required knowledge: Delphi, SQL
Looking for a Delphi program D7 that could generate SQL UPDATE statements automatically from a source table for predefined columns like PRICE ONHAND etc based on other columns on the that table . The Goal of this project is to create the least amount of UPDATE statements that would run on target tables to update the few fields that need to be updated, and palce the statements in a Script-file So let’s say if ALL of Model A1 and Model A2 is priced $ 100 And model A3 size 49 is also priced $ 100 it would be only generate one stament And A3 size 58 length long is $ 58 it would be a other select statement. The other part of the project would be a program to run on the Target table and give the program a list of fields to update, so even if the scrip-file has a statement to update also other fields only the field in the list would be updated, unless i dont give a list . The programs has to be to run from a cmnd line with no GUI It could use some INI files and send the INI file as a parameter to to program The tables are DBF and ADT tables from http://www.sybase.com/products/databasemanagement/advantagedatabaseserver |
Job Categories: |
DelphiSQL |
Related projects: |
|
|
Dynamic product display system100% usable by the editor.Note that colors, fonts etc. must use the custom.css file as described. Position, data item and all variables must be meaningfully named and easily identifiable in the code, so that I can make simple changes to the layout myself. More detail is available in the uploaded spec document, and I will supply the Vendor with clear visual images + measurements of how the pages and menu-disply in the spec should look. |
Simple Table Join And Update: ".$ row['description']." WITH ".$ row['title']."<br> 1st & 2ND url: ".$ row['gallery_url']." WITH ".$ row['gallery_url2']."<BR><hr>";$ counter = $ counter + 1; } echo "TOTAL ROWS AFFECTED ".$ counter."<BR>"; echo "DONE....."; ?> _______________________________________________________________ Basically the gallery_url does not correspond with gallery_url2 |
Classifieds Site Modifications.4 General site security check. Make sure site has defence from sql injections and other possible attacks ie flood. A small part of the code is encrypted but i have the functions.php file needed to make it work. I won't escrow payment until you have looked at the job and are confident you can do it. All fairly straightforward if you know what you're doing. Please do not bid if you do not have experience in this field! More work for the right person. |
Sql Insertion To Photo Script> }} else $ this->_errors[] = $ this->_lang['E_TYPE']; } function _errorMsg() { $ this->errorStr = implode('<br />', $ this->_errors); } } ?>[/code] Can someone show me how and where to stick the sql statement and the variable(image_name) that represent the new file name and Extension. Thanks in advance, Batoe |
Facebook app - top urgentEmail notification is a must whenever stuff added to site. I have in hand 4 facebook application projects and once one project is successful, all 3 will be awarded to the same coder. so please mention in your bid whether you can handle multiple jobs or not and how about your designing skills. Do mention your hourly rates. any questions please ask. I need this done with in 1 week. This is very simple job for someone who knows what he is doing. |
PHP Form on Win Oracle Databaseite PHP pages for front end UI with professional design and layout for maximized user experience- Write a backend database connector to process connections, get/send parameter and data between frontend UI and oracle db - backend database connector must also process and generate SQL statements with data gathered from frontend UI - Deny access for unmatched password. Please refer to attached file for project detail and form layout. |
4 Simple update, delete, and insert query type php pages. $ 30 in total for this projectthe existing database lsiting.3) An add entry to database page that will insert the contents of the form into the database, with the form containing the same fields as the database table. 4) A page that pulls up the shipping table (which has only 2 columns, model_number and price) so you just need to have it pull the row that matches to the model number in the url post, and once again display a form for editing the price and updating the database entry |
Oscommerce Data Import Programsuch as product code, name, description, import date, ETA, GST or not( all should be GST yes)price exclude GST, price include GST( it is price exclud GST x10%), product status( all should be in stock, value in database should be 1), quantity, picture( suppliers's datafeed include picture library. If some do not have, just put is blank or default picture), products url(can be set to blank, products weight( if not available, can be set to default weight)... others we can ignore it. |
FDF/PDF File Form to HTML or ASP by salvetauot; & RS("CustomerID") & "'"RS.Close NewSchool.Execute(sql) NewSchool.Close Set RS=Nothing Set NewSchool=Nothing</SCRIPT> ----END CODE----- I do not want to be depending on any adobe file and we want to have this page generate an ASP or HTML file instead of a PDF file. If you do not understand any of this let me know... Payment. Payment will be provided once project is completed. |
Need page built to parse order data from URLoad/ss%20copy.jpg |
Movie theme website;t just say you can do it... back it up, in detail please. |
PHP Programmer needed for custom PHP siteeated and managed in the backendo We may want to go tw |
Run Mysql Queries Using Xml In Phpquery_fetch_array() - Simulates mysql_fetch_array()query_fetch_row() - Simulates mysql_fetch_row() count_rows() - Simulates mysql_num_rows() get_result() - Simulates mysql_result() get_error() - Returns any obvious syntax errors on the last query submitted to the run_query() function. I would need exclusive ownership and copyright of the code for this script. Please let me know if you have any questions or need any clarification. |
Java process parameter drivenbr>Ping me if you have any questions. Regards, |
Movie autoblogeep in mind I´m a simple guy, not with a big budget. |
php coding helptp://pagead2.googlesyndication.com/pagead/show_ads.js">Additional files submitted: (Files are only available for logged in users) getdata.php |
Repair and Upgrade SiteI already have the banner.I look forward to your bids. |
Oscommerce Contribution Install & ChangesOption to turn on or off rewards based on Customers Group. |
Php Coder For Network Jol call home to our server every 10 minutes.It will read all http header/traffic of the network's computers. It will rewrite the http headers per our instructions. The application will be distributed via a small exe. The exe is not to load up the computers at all. The exe will update itself automatically when there is a more recent version on our server. You will not be allowed to sell this code elsewhere - ownership rests with us. |
database dumpsurl? 6)NameThe Software should be made automatically database dumps from differnt websites. Additional files submitted: sql.pdf |
