<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 12/16/2013 4:28 PM,
<a class="moz-txt-link-abbreviated" href="mailto:ken_wakeman@me.com">ken_wakeman@me.com</a> wrote:<br>
</div>
<blockquote
cite="mid:1056649232-1387232913-cardhu_decombobulator_blackberry.rim.net-1310741091-@b12.c3.bise6.blackberry"
type="cite">
<pre wrap="">
Does anyone have a example of creating a new file on filepro(5.7.03) on sco
For example ... What would a DSN description format be ?
Same as the fp docs examples ..
Ken
Sent from my BlackBerry device on the Rogers Wireless Network
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
Ken,<br>
<br>
Here is mine;<br>
<br>
<font face="Courier New, Courier, monospace">[root@alpha etc]# cat
odbc.ini<br>
[fp-connector]<br>
Description = MySQL connection to 'myroutes' database<br>
Driver = MySQL<br>
Database = myroutes<br>
Server = localhost<br>
User = root<br>
Password = ##############<br>
Port = 3306<br>
Socket = /var/lib/mysql/mysql.sock</font><br>
<br>
You must also edit /appl/fp/MySQLstored_procedures/all.sql.<br>
<br>
<font face="Courier New, Courier, monospace">DECLARE indexCursor
CURSOR FOR<br>
SELECT `COLUMN_NAME`<br>
FROM `INFORMATION_SCHEMA`.`STATISTICS`<br>
WHERE `table_name` = in_tableName<br>
<b>AND `table_schema` =
'your_database'</b><br>
AND `INDEX_NAME` = in_indexName;<br>
<br>
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;</font><br>
<br>
Then you need to run /appl/fp/MySQLstored_procedures/all.sql against
your database;<br>
<br>
i.e.<br>
<font face="Courier New, Courier, monospace"># mysql --user=USER
--password=PASSWORD --database=DBNAME <
/appl/fp/MySQLstored_procedures/all.sql<br>
<br>
<font face="Helvetica, Arial, sans-serif">If you have multiple
databases you must run this for each one. Make sure you edit the
all.sql and change <br>
</font></font><font face="Courier New, Courier, monospace"><font
face="Helvetica, Arial, sans-serif"><b>`table_schema` =
'your_database'</b> before you run it.<br>
<br>
Here is the filepro setup when you create your table;<br>
<font face="Courier New, Courier, monospace">ÚÄÄÄÄÄÄÄÄÄODBC
Connection ConfigurationÄÄÄÄÄÄÄÄ¿<br>
³ ³<br>
³ DATABASE: TXOAG þ ³<br>
³ TABLE: addl_addr þ ³<br>
³ DSN: fp-connector þ ³<br>
³ SERVER: localhost þ ³<br>
³ PORT: 3316 þ ³<br>
³ USER: root þ ³<br>
³ PASSWORD: ########### þ ³<br>
³ ³<br>
³ ³<br>
ÀÄÄPress ESC ESC -Test Connection Del -CancelÙ<br>
<br>
<font face="Helvetica, Arial, sans-serif"><font face="Times
New Roman, Times, serif"><font face="Helvetica, Arial,
sans-serif">Also, make sure the first field, or some
field, in your sql table is "id" with auto-increment.<br>
This is used by filepro as a "record number".<br>
<br>
Any indexes built in the sql will come up automatically
in the order they are made as A, B, C, etc..<br>
If you need to create indexes here is an example sql;<br>
<br>
CREATE INDEX outto_status ON wip_web_test
(`outto`,`status`,`status_date`);<br>
<br>
If you need to delete an index:<br>
<br>
DROP INDEX outto_status ON wip_web_test;<br>
<br>
Finally, see all indexes on the table:<br>
<br>
SHOW INDEX FROM wip_web_test;<br>
<br>
Hope this helps,<br>
<br>
Richard D. Williams</font><br>
</font><br>
<br>
</font></font></font></font>
</body>
</html>