SOLCASE TIPS - MAY 2007

USING EXTERNAL FILES AS A DATA SOURCE

There are times when you may want to store information outside of Solcase and read it back in. One example might be for conveyancing quotation fees. You may have more than one matter type that uses the same figures so rather than store them in a script in Solcase you can use the [&Import] command to read a text file stored on the server. The advantage is that there is just one file to update and creating a little text file in Notepad takes a fraction of the time required to program a script in Solcase with endless &If commands.. Whilst there is a Fees table reading the contents into your scripts or letters is complex. Whilst this code could also be used in Visualfiles you would be better to create a fees table and link it appropriately.

The sample code reads a simple text file called LandRegFees.txt a copy of which is set out below the code. The data has been separated using the pipe (|) sign. To update the fees simply change the figures in the text file.

Obviously you can assign the price in your database to TF02 and assign TF01 back to the database field that holds the Land Registry Fee.

SAMPLE CODE