Posts by debasisdas

This may help.

This approach (with 3190 parameters) is impractical.

You need to try some other method to achieve the same.

Store the data in CSV into database and use it as desired.

Hi Yamna,

Welcome to Daniweb.

Hi Ashfaq,

Welcome to Daniweb.

I quit.

This is what happens to all those who try to reinvent the wheel.

When data is stored in a database, physical position is not at all important and the user has hardly any control over the.
No code can do that for you.
You can only display that at the top.

a c/c++ program to add a user to MySQL and allow him to only insert into the database

if you want to add an user and allow only insert why you need to create a table from c++ code. Please post your c++ code in the c++ forum only.

2100 parameter !

for what ?

Please post your code here and get it rectified with our experts.

You need to loop through all the text boxes on the form and check if it empty.

If anyone is empty prompt the user to fill that.

is it compulsory to add value to all the text boxes ?

First lets know how familiar and how comfortable you are in coding VB 6.

Yes, in either.

Your post shows you are new to using database so trying to use an unrealistic approach.

I don't see a single benefit of this approach, neither size nor performance wise.

What you will do when again some of these (modified) ids gets deleted, you again have to maintain the data. I think this is the only outcome of this process, more frequent maintenance.

If you still think i was not trying to help you and you are adamant to use your approach, god bless.

Check for proper join and existence and use of indexes in the table structure.

Lets see your validation code that you are working on and fix it.

You need to crate tables in the DB as per the fields file and to load the data in the text file it needs to be properly formatted.

First look at your data shows it is not properly formatted.

Create a routine in MySQL to handle all that at DB level and call the same from c/c++ program.

Using the owner argument with the Show method ensures that the dialog box will be minimized when it’s parent is minimized, or unloaded should the parent form be closed.

Using the Show method with both style and owner arguments.

For example:

' Display frmAbout as a modeless child of frmMain.
    frmAbout.Show vbModeless, frmMain

If the records are already deleted and the ID field is the PK of the table it is not going to have any effect on size or performance.

If your .SQL file contains insert scripts, use that to insert records into the target DB and then use any DB front end tool to export the data back to .CSV format.

Then you need to lit a candle as well.

You can go ahead and implement the approach if you have proper back up and recovery mechanism. Remember you are putting all the eggs in a single basket.

what is the problem with current code ?

In which part you are struck ?

What exactly you are trying to do ?

Welcome aboard.

Do you have any code that you are working on ?

I want to understand what is the problem if the id values are not continuous. As you said this field is the PK of the table, is it not referred by any other table ?

the table rows now are jumping

I really do not understand what exactly you mean by that, are you trying to re arrange the ids starting from 1 and increment by 1 till the last record ?

Welcome aboard.

Better to do that in a procedure.

try this sample code

UPDATE table1 SET field1  = '0'||field1 
WHERE (field1 LIKE '1%' OR field1 LIKE '7%')

NOTE:-The above code is in oracle syntax, you have to change to mysql

What exactly is the problem ?

Welcome aboard.

Do you have any field in your table that stores transaction time ?

If yes, sort by descending order on that field.

Check for the 1st character of the string ,if that start with 1 0r 7 concatenate with 0.

If the file is in purely text format then fields does not make any sense.

How to differentiate between data from one field to another ?

If it is in delimited format, it will be easy to load it into DB and then use the data to create graphs.

But i don't understand what pagination has to do with database design. That should be handled at application level.

How are you populating the data grid ?

What the file contains and why you need to decode and using what ?

That should work.

Before insert check if the same record already exists (to avoid duplicate).

Your SQL syntax is wrong.

Nice requirement ?

what have you done so far ?

Don't be serious, be sincere.

Sharpen your pencil first.

Please read more here and here.

Does you text file contains data in multiple columns ? How you distinguish between columns in a text file ?

You need to read books for all that.

Try using any search engine will get a lot of code online.

How are you reading data from text file ?

That so simple, just by writing some code.