Stack Overflow
Stack Overflow

Questions tagged [c-treeace]

10 questions
2
votes
1 answer

How do I get my UPDATE statement to function on ctree?

So I am writing a script that both inserts and updates based on a certain condition. I have the insert statement finished but having a hard time trying get my UPDATE statement to work in CTREEACE DATABASE script section. If there is anybody familiar…
AceNinja1101
  • 63
  • 6
2
votes
2 answers

How to read .DAT and .IDX files using C Tree

I've got a program that I am trying to get data out of. I have been unable to find any sort of Database file to open. In the parent directory of the program there are a bunch of .DAT and .IDX files. The program also installed the C-Tree GUI…
Fuzzerker
  • 249
  • 1
  • 6
  • 15
1
vote
1 answer

For my data insertion method how do I check that the values from the pulled data from the database are being passed correctly or if at all?

Okay so from my previous question this is one iteration of how I am pulling data from the SQL Server and then inserting that same data into CtreeACE where the table is already setup for the values to be stored in there. When I run the code I…
Bartholomew Allen
  • 21
  • 5
1
vote
1 answer

What is wrong with the syntax of this SQL statement I am using to create a table?

I keep running the code/debugger and even set break points so I can step through the code and haven't been able to find where what the syntax error is I know its within this C# method for creating a new table in the c-tree database. Here's the code:…
AceNinja1101
  • 63
  • 6
1
vote
1 answer

How do I create an index using the FairCom c-treeACE CTDB API?

Here is my code based on the CTDB tutorial. #include #include #include "ctdbsdk.h" /* c-tree headers */ #define END_OF_FILE INOT_ERR /* INOT_ERR is ctree's 101 error. See cterrc.h */ CTHANDLE hSession; CTHANDLE…
Ray Hulha
  • 10,701
  • 5
  • 53
  • 53
0
votes
1 answer

How does one pull data from SQL Server and insert that same data into ctreeACE? (in real time)

Okay so I am writing a C# script that pulls data from an SQL Server and then within that same script inserts the pulled data into the already made table for the pulled data to go into. I would like bounce some ideas to see if anyone would also help…
Bartholomew Allen
  • 21
  • 5
0
votes
3 answers

Is there way to insert the same data into multiple columns is SQL?

Let's say we wanted to put the same data into multiple rows like so. Column names for this example: Monday, Tuesday, Wednesday, Thursday, Friday INSERT INTO sample VALUES ('long string') This is an example of what I mean so the same value is in…
Bartholomew Allen
  • 21
  • 5
0
votes
1 answer

The following script does not work in c-treeACE when I try to insert 5 rows at time, why is that?

Given a set of data and trying to insert all of the rows into the table it seems c-treeACE throws me an error message saying its a syntax error and highlights the zipcode here is an example: here is the script: INSERT INTO testdata VALUES …
Bartholomew Allen
  • 21
  • 5
0
votes
1 answer

How to import a csv into c-tree

I am using ctreeACE to create a local database, and I was given a csv file that contains 1000 entries of data and wanted to know if there was a way to import it without hard coding it? Right now I am having to insert line by line with: INSERT INTO…
Bartholomew Allen
  • 21
  • 5
0
votes
1 answer

How can I export data from a c-tree program?

I'm in the process of consolidating our old stuff into TFS. One of the old things is a bug report repository. I believe it's using c-tree to store data, because it has .idx and .dat files. Id like to try to export all of this data into a txt/csv so…
user1538717