Original concept inserting a row in the dw_1, data, update the database, how to write?

CodePudding user response:

Create one row, set values, the following sample code
Long ll_row
Ll_row=dw. Insertrow (0)

Dw. Setitem (ll_row, "column", "set the value of")
.
.
.
Keep update, the code is as follows:
If dw. The update ()=1 then
Commit the using the sqlca;
The else
The rollback using sqlca;
Messagebox (" prompt ", "save failed!" , stopsign!)
end if

CodePudding user response:

Table's primary key can't add a primary key for grey situation thank you!

CodePudding user response:

Your question best give a screenshot, otherwise, I don't know what are you doing

CodePudding user response:

reference Dersak reply: 3/f

you'd better give a screenshot, this problem otherwise, I don't know what you're doing

Only in the original concept database palette established a simple table, but don't to guide how to set the primary key, gray,
Other structures for two columns,
The first column "translation" 20 no Varchar (null);
The second column "Tag" Varchar 20 yes (null),
Without adding data line,

CodePudding user response:

Posting also too not serious, that you call what others give you answer seriously,,

CodePudding user response:

reference 4 floor xiaominihao response:

Quote: reference Dersak reply: 3/f

Your question best give a screenshot, otherwise, I don't know what you're doing

Only in the original concept database palette established a simple table, but don't to guide how to set the primary key, gray,
Other structures for two columns,
The first column "translation" 20 no Varchar (null);
The second column "Tag" Varchar 20 yes (null),
Without adding data lines,

Directly is
The first column "translation" 20 no Varchar (null) primary key,
The second column "Tag" Varchar 20 yes (null),
Try it ok

CodePudding user response:

If you are do with sketchpad database table design, then make decision method is the key, after when you create all the columns, save, and then, put table to pull out the object on the layout page, in the blue area of the point on the header right new=& gt; Primary key, and the rest will be on the right can be set parameters,

CodePudding user response:

refer to 7th floor Dersak response:

if you are do with sketchpad database table design, then make decision method is the key, after when you create all the columns, save, and then, put table to pull out the object on the layout page, in the blue area of the point on the header right new=& gt; Primary key, and the rest will be on the right can be set parameters,

Primary key is gray, can't use,

CodePudding user response:

refer to 7th floor Dersak response:

if you are do with sketchpad database table design, then make decision method is the key, after when you create all the columns, save, and then, put table to pull out the object on the layout page, in the blue area of the point on the header right new=& gt; Primary key, and the rest will be on the right can be set parameters,

Primary key is gray, can't use,

CodePudding user response:

What do you use the database? Don't suggest you to create a primary key, pb database sketchpad function is not too good, suggest you use the same SQL,