Create a table in Flexibility

[Bokk]

I am new to Macola and trying to get familiar with Flexibility and more familiar with VBA. From reading posts Flex is unique in some ways and has some limitations.

We are looking to move our inventory into Macola ES 360. I need to map and import the fields from our legacy system to Macola and it would be nice to have a better feel for the tables. Even within the Items tables there are fields that I would like to have a little more information about their function. Then I need to make sure I'm populating all the related tables. Do I just learn this trial and error or are there properties, documentation, etc that I can look at.

I am also looking for a way to add a new table (we need to extend the data in our inventory to include information on their chemistry makeup). Is it best to use Flex or are there better options? I have not been able to find any documentation on this specifically or the way to add it in Flex.

Thanks,
SGM

 

[abaldwin]

As for the 1st part of the question I would suggest you work with a VAR to tanslate your data accurately. There are plenty around but one I know is really good is gainfocus.biz

As for the second part Flex would be perfect for manipulating data in your own tables. Userforms, ado connection, and sql statements and you are on your way.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[Bokk]

So to back up one step, can you actually create the table in Flex or would that have to be done in SQL or something? Then create a userform, write modules, etc. to manipulate it.

 

[abaldwin]

Using an ADO connection you can definitely create the table, say if it does not exist, populate it etc all in one piece of code.

Delete it after you are done for that matter.

I will not write the code for you since this is how I make my living most of the time, but I can point you in the direction of

Using Flex

ADO connection.
Connect to the db (straight forward)
Check for the existance of the table on the userform activate event.
if it does not exist then
create a sql string creating the table. (Plenty of SQL examples for this)
execute the sql using the ado connection
end if

more code here for doing whatever you need in the way of manipulating the data in the table.

These are all pretty common VBA steps, since flex is by definition "Macola's implementation of VBA in Macola" - (My own personal definition btw) you can do all this.

You do not need access to SQL as you call it, I believe you are talking about Enterprise manager, you can do all this from code.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[Bokk]

Thanks for the outline. I'll create a new table and see what I can do with it.

Thanks again,
SGM