How add records to a file associated with an external dictionary

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
dduarte05
Posts: 11
Joined: July 8th, 2014, 12:47 pm
Location: República Dominicana

How add records to a file associated with an external dictionary

Post by dduarte05 »

Dear colleagues, good evening.

In addition to reading and writing in a file associated with an external dictionary, can I add records?

The Sqlquery function with the INSERT INTO statement table1 (column1, column2, ..) VALUES
(value1, value2, ...); Can it be used for that purpose?

regards
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: How add records to a file associated with an external dictionary

Post by htuser »

In CSPro logic, there's two way to insert items values, not all records item's, in an external CSDB files or a Sqlite files.

1.- Writecase function: http://www.csprousers.org/help/CSPro/wr ... ction.html , this specially for CSDB associate with external dictionary;

2.- Sqlquery with insert into for any CSDB or Sqlite file. However, Josh doesn't advise to create table and insert into in a CSDB files. So, it will be
very important to create a new Sqlite DB file and insert into any values. In the past, usualy i'm using this way for storing items, records values
(one by one). In the future this will be more easy in CSPro logic since we could have:
a) A way for sqlquery to extract records so do items values, so we'll be able to insert a whole records in any sqlite table;
(http://csprousers.org/forum/viewtopic.php?f=10&t=2592)
b) A way to create new secure sqlite DB (with credentials).

However, we can't smart sync sqlite DB in CSPro logic, so it's important to know if you want inserted values locally.
Best Regards,
G.VOLNY, a CSProuser from Haiti, since 2004
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: How add records to a file associated with an external dictionary

Post by josh »

You can use the insert() function in CSPro logic to insert a new occurrence of a record into a case in an external dictionary. You can then use writecase to save the case.
dduarte05
Posts: 11
Joined: July 8th, 2014, 12:47 pm
Location: República Dominicana

Re: How add records to a file associated with an external dictionary

Post by dduarte05 »

Thanks;
Post Reply