IDEAScript Questions

Hello,
 
I'm sorry if my question is basic but I would like to know how to get for example the value of the first column and the second line in my Idea's database ?
Thanks in advance !
Benoît

Hi
Please help
 
I have 2 tables
1st table contains value (e.g. 2, 8, 13, 17, 55, 104,)
2nd table contains 3 columns. 1st Column Start range, 2nd column End range, 3rd Column value)
I want to build a query, where second column will be added in 1st Table.....which will contain criteria and will query the value in 1st table and check the value betwene Start and End range of 2nd table...if the value is between the start and end range...then it will give the corresponding value in 3rd column of 2nd table.
E.g.
1st Table
Value

Hello,
How do i abort execution of an Idea script ?
I didn't find answers in the forum.
thank you
 

Hello Brian
 
I am working in a credit analysis and I need to create a database from scratch and populate it with data taken from another database, this process is repeated several times with different tables in a loop, but all of them have a similar structure where all the fields (except the last one) are numeric with two (or four if needed) decimal places and the last field is a date field.
My data has usually decimals values and sometimes low integer values, that is why it  is very important for the analysis to preserve the data exactly as it is.

Hi all, i need some help with a script i'm writing, it's a financial analysys, for debit and credit movements.
First i'm direct extracting by two criterias and because of that it creates me 2 new databases (the criterias are the account numbers).
After that i need to append them and do a new direct extraction with some new criteria (the criteria is the amount).

Is there a way to grab the current critera and then change it without extracting a database? For example, say I import a general ledger into IDEA that has 5 columns:
1) Customer_Name
2) Debit
3) Credit
4) Reference
5) Account_Number

Hi folks,
I'm wondering is there an IDEA script function to Expand All ?
I'm running a macro that creates mutliple databases and I'd like to finish by expanding the list in IDEA file explorer.
Thanks a million
Phil

Hi Brian,I have been watching your pages for a long time and I consider them very useful. There is not much documentation about the ideascript itself.

Hello everybody,
 
I've been working on a macro that allow users to import a database using a ODBC connection. The last step I want to implement is allowing the user to type a Select Query in the text edit box en use that query with the clien.importODBC function. The query works and so does the ODBC connection, however in Query language you might want to use a ENTER every now and then to clean up the code a bit.
As a Example:
Select * from Tablename
where  column = "IDEAScripting.com Example"
 

Hi,
I would like to create an .exe file from a macro I created which integrates a python script. My problem is that when I build the executable file and try to run it on another machine (without importing the pyhton script) it doesn't work.
Is there a way to create an executable which already integrates the python code, so that the final user does not have to receive also the .py script?
Also, is it possible to create an executable which doesn't require to be included in the 'Macros' folder of the IDEA project?
Thank you, Ttx