Co-production funding came from WGBH Boston.Louis Marks originally wanted to make a film adaptation of the novel but abandoned the project after a lengthy and fruitless casting process. The serial starred Hugh Dancy as Daniel Deronda, Romola Garai as Gwendolen Harleth, Hugh Bonneville as Henleigh Grandcourt, and Jodhi May as Mirah Lapidoth. 
The serial was directed by Tom Hooper, produced by Louis Marks, and was first broadcast in three parts on BBC One from 23 November to 7 December 2002. The drama took a further five years to make it to television screens. Filming ran for 11 weeks from May to August on locations in England, Scotland and Malta.
The connections from the data model editor are performed in 64 bits. If a connection is performed toward an external database, the client or ODBC driver or OLE DB provider of this database must also be installed in 64 bits. The former Hyper File 5.5 analyses cannot be imported.
HiI need to connect and use and SQL Server database. I created an ODBC object on my computor called Kruncher I created a connection with the following code:ConnectionNum is intSourceName is string// Connection to a specific data source via ODBC MS ACCESS// (Mark: some drivers open a file picker// if no file is associated with this data source)SourceName = 'Kruncher'ConnectionNum = SQLConnect(SourceName, ', ', ', 'ODBC')IF ConnectionNum 0 THENInfo('Process completed')ELSE// The connection failed: display an error messageSQLInfoError('The connection to the data source' + SourceName +.' Error code: ' + SQL.Error + CR + SQL.MesError)END// In any case (connection successful or not)SQLDisconnectIt connected. Now don't laugh but what do I do next. I want to be able to add records to the database, delete and update records.
Could someone point me in the right direction to find the help or give me a little help. Do you just use the H- commands but how does WD know you want to work with the sql server database. Is there an alias. Any help at all I will be thankful for any help I get. I have never worked with any database besides hyper file. Do you make this sqlserver database the default db for my app so I can just go HAdd HNext and so forth and if so how do you make it the default. Can someone please help.Thanks In AdvanceJohn.
HiI got the connect to work and make the connection, but I have gone through all the help and can not find any example code at all that shows you how to work with the data. Here is my code:MyConnection = 'Kruncher'IF HDescribeConnection(MyConnection, ', ','ServerSQLServer', 'dbo', hOledbSQLServer, hOReadWrite, ')Info('It worked so far')ENDHOpenConnection('MyConnection')HChangeConnection('races', 'MyConnection')HReadFirst('races')Now how do you change the values of a field in the table?When working with my tables in the analyst I could just type races.racedate = '20120220' then do an HUpdate to update the recored or HAdd to add a record. I have found a lot of examples to make, change a connection but no examples on how to work with the data once I have the connection made. Could someone point me to some example code that will show me how to do this. Many thanks.John. QuoteRAUL2QuoteGuenterPHi John, no, don't use odbc, rather use hOledbSQLserver. The interesting thing: it works with h-commands.
At least two years ago it did. Regards, GuenterSo, you're saying there's no need of using native access in order to work with Sql Server? I haven't a Sql Server at hand to try it. It would be great to use Hxxx functions in order to upgrade an app from HF to Sql Server, if needed, without native access.If the answer is yes; is it slow as the help says???Regards.Hi, it is slower, of course. However, according to our WinDev customers using OLE DB instead of their Direct Access the difference is small if not unnoticeable in small LANs up to 10 client computers. It's assumed that Direct Access will add some speed in larger networks.
So, if need arises they'd simply add Direct Access at some stage. Currently they're happy with OLE DB though there are hundreds of 'database tables' in use. Regards, Guenter. Garritan personal orchestra kp2 updated. HiI got the connect to work and make the connection, but I have gone throughall the help and can not find any example code at all that shows you how towork with the data. Here is my code:MyConnection = 'Kruncher'IF HDescribeConnection(MyConnection, ', ','ServerSQLServer', 'dbo',hOledbSQLServer, hOReadWrite, ') Info('It worked so far')ENDHOpenConnection('MyConnection')HChangeConnection('races', 'MyConnection')HReadFirst('races')Now how do you change the values of a field in the table?When working with my tables in the analyst I could just type races.racedate= '20120220' then do an HUpdate to update the recored or HAdd to add arecord.
I have found a lot of examples to make, change a connection but noexamples on how to work with the data once I have the connection made. Couldsomeone point me to some example code that will show me how to do this.