How is SQL Snapshot control used?

HCL Domino Domino Forum
1

Hi all,

We have got an application which use SQL tables. We want to get report page on lotus client. We have design it but it is not enough to use with biggest data.It returned error which calls “Error - field size can not be large 64 K”. We have never used Object and its controls. Can we use SQL Snapshot control for report page?

Thanks for any help.

Regards

2

Subject: How is SQL Snapshot control used?

The error you are getting is caused by to much data being returned to a dblookup.

I do not understand what you are trying to do?

What is SQL Snapshot?

3

Subject: RE: How is SQL Snapshot control used?

Hi,

We want to prepare report page in notes client.Application is designed for purhasing workflow.End of the month our managers want to get montly purchasing report.report contains 5 column Month - Departmant, etc…, Data stored in SQL Server so it’s reaaly hard to get data and proepare report. We are seeking a tool for report. So we find SQL Snapshot control in page design(designer) - Create → Object menu. We want to learn how to use this control and is it useful for us?

Thans

4

Subject: RE: How is SQL Snapshot control used?

Based on my reading of Microsoft SQL Snapshot Control 8.0 would do the job that you are seeking.

I assume that you have Microsoft SQL Server 2000, and that is why you are asking.

See the article “How Snapshot Replication Works” at Technical documentation | Microsoft Learn